Microsoft Query - Excel Subtotal Refresh

[Takes2ToTango]

Hi all. I have a Microsoft Query that I initially removed subtotals. I then use the user form to change the query date using two parameter cells. This then refreshes the query as it is supposed to. However, when I read the subtotals back in again, the query refreshes itself and screws up all of the data. This doesn't happen on the dates that are already in the parameter or already filtered, only when a new one is added in. Is there any way to prevent this refresh? (Unfortunately I cannot add a sample of data due to the contents)

Sub RunData()

Application.EnableEvents = False

Worksheets("OT").Range("A4:G579").RemoveSubtotal

UserForm1.Show

Application.EnableEvents = True

End Sub

Sub removesubs()

Application.EnableEvents = False

Range("A3").Select
ThisWorkbook.Connections("Connection410").Refresh
    Selection.Subtotal GroupBy:=1, Function:=xlSum, TotalList:=Array(5, 6), _
        Replace:=True, PageBreaks:=False, SummaryBelowData:=True
        
Application.EnableEvents = True
End Sub

 

[Takes2ToTango]

Figured out the solution for any future references. Due to the two parameters, both refresh on the cell was activated. Turning this off and putting a table refresh in solved the issue.