LinkBack URL
About LinkBacks
Hi
I have recorded a macro that will refresh a pivot on sheet1, however when i run this macro from sheet2, the code brings up an error.
Is there anyway I can sort this?
Hi
I have recorded a macro that will refresh a pivot on sheet1, however when i run this macro from sheet2, the code brings up an error.
Is there anyway I can sort this?
Hi! Just add this code to a Module and it will refresh all your Pivot Tables in the Workbook:
Please Login or Register to view this content.
excelbat.com: free Excel tools, macros...
In case you don't want to refresh every pivot table in your workbook, if the name of sheet 2 is "Sheet 2" (with the space between sheet and 2) then you can use this:
You can adjust the name to fit whichever worksheet or pivot table you want to refresh.Please Login or Register to view this content.
Some people volunteer in soup kitchens or hospitals. I choose to make the world better by trying to help you with Excel. We're all learning.
<---Click * Add Reputation for all helpful comments. It's like giving a smile.
Forum Rules: How to mark your post [Solved] and have a happier, Excel enriched life.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks