Is there a way to set up a pivot table so that it automatically refreshes when data is changed?
Is there a way to set up a pivot table so that it automatically refreshes when data is changed?
No, unless you used VBA for it.
I can't help you (enough) with the solution in VBA.
Notice my main language is not English.
I appreciate it, if you reply on my solution.
If you are satisfied with the solution, please mark the question solved.
You can add reputation by clicking on the star * add reputation.
Here ii one VBA option:-
Put this code in each sheet (in the VBA window) that have Pivot Tables.Please Login or Register to view this content.
The code will run every time you click the sheet tab.
Regards
peterrc
Here ii one VBA option:-
Put this code in each sheet (in the VBA window) that have Pivot Tables.Please Login or Register to view this content.
The code will run every time you click the sheet tab to open the sheet..
Regards
peterrc
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks