I have multiple pivot tables all on different worksheets. I also have a server queries from which the pivot
tables draw from. I would Like to click one button and have both the server queries and pivot table refresh.
This seems to be the most elegant way, but maybe it is instantaneously refreshing both the query and pivot table, that the
pivot table isnt updated with the new info from the query? I say this because it will refresh the server queries, but not the
I have also used a seperate module to refresh the server queries, and then tried using
dim w as worksheet, p as pivottable
for each w in thisworkbook.worksheets
for each p in w.pivottables
all in the same sub, but the pivot tables refuse to refresh unless I go to the sheet which contains the unrefreshed pivot
table, right click, and refresh data.
I am thinking possibly a module to call in my sub, inserted after my query
refresh sub, will refresh the pivot tables which draw from the server query.
Anyone else have any ideas or
insights into what I am doing wrong?
Thanks in advance