Morning All,
I am looking for a way to be able to refresh a pivot table after my SQL Query has refreshed.
I tried to record a macro of a manual refresh on both tables, but the PivotTable refresh happens too quickly, so the SQL Server hasn't refreshed.
Any help would be greatly appreciated.
Many Thanks
Ross
If you turn off the background query option for the connection, it should allow your code to refresh the query, then the pivot table in the correct order.
Everyone who confuses correlation and causation ends up dead.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks