|re: "I don't believe it triggers the change event."|
Well, that's kind of an important piece of information to know and worth testing.
If the Change event is triggered, then we've found the solution.
If not, a "time-based" macro is possible, but I'd rather see the code triggered by an actual Event as opposed to depending on a clock which may or may not coincide with the update, etc. I just see more potential problems with 2 independent operations, one assuming the other has happened, as opposed to the first one actually causing the second.
A simple test would be this:
Right click the sheet tab for the sheet that does the query and choose View Code. Paste this into the window that opens. If the change event is triggered, the MsgBox will pop up and we'll have our answer.
Important Note! Where the code says "A1:A5", you need to put in the actual range that gets updated, or at least some range of cells that you know will change.
Another Important Note! You may want to back up your original spreadsheet in case something goes terribly wrong. Better yet, create a new workbook, paste the code in and run a query or 2 to see if the Change Event is triggered.
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("A1:A5")) Is Nothing Then
MsgBox "Update Triggered Change Event!"