LinkBack URL
About LinkBacks
You have to Right click in the Pivot Table and choose REFRESH. You may be able to have this done via macro but Pivot tables don't naturally update dynamically.
You have to Right click in the Pivot Table and choose REFRESH. You may be able to have this done via macro but Pivot tables don't naturally update dynamically.
<---------If you like someone's answer, click the star to the left of one of their posts to give them a reputation point for that answer.Ron W
Thanks! My first pivot table, so I'm (or was) a hopeless noob.
However, I added this code to my VBA script and now it auto-refreshes:
ActiveSheet.PivotTables("Table1").RefreshTable
Thanks! My first pivot table, so I'm (or was) a hopeless noob.
However, I added this code to my VBA script and now it auto-refreshes:
ActiveSheet.PivotTables("Table1").RefreshTable
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks