Refresh data table using VBA

[mr_hiboy]

Afternoon,

I need some help with what I thought was a simple refresh.

I'm trying to create a button that will update the data in a hidden sheet. I use this same code in a different file and it works fine, but this new file is using a data table.

ActiveWorkbook.Worksheets("2015 YTD").Range("E8").QueryTable.Refresh BackgroundQuery:=False

Any help would be appreciated.

thanks

 

[Luke M]

Not as precise, but if you don't have a bunch of other PivotTables or something, you could do:

ThisWorkbook.RefreshAll

which will refresh all Data sources in your workbook.

 

[mr_hiboy]

Cheers Luke - I got so obsessed with "It works on another file" I didn't see the obvious.

Appreciate the help.