Excel Productivity Guide
Useful Excel Tips | Keyboard Shortcuts | VBA Codes
Download this Free E-Book to take your excel skills to a whole next level using some smart Excel tactics.
Worth $20, Absolutely Free
A pivot table is one of the best things that I have ever used. I love the thing that I don’t need to insert it again and again. It’s a one-time setup.
It saves a lot of time because once you create a pivot table, you just need to refresh it with a single click when you update it and it’s a one-second job.
The problem is when you have multiple pivot tables. You need to spend one second to refresh each pivot table.
And, that’s why we should have a method to refresh all the pivot tables at once.
So today, in this post, I’d like to show you 3 simple methods which you can use to refresh all the pivot tables with a single click at the same time.
So let’s get started.
"Refresh All" button is a simple and easy way refresh all the pivots tables in the workbook with single click.
Go to Data Tab → Connections → Refresh All.
If you want to refresh all pivot tables on opening a workbook, you can use following steps to make one time to set up for that.
Yes, you can use VBA as well to refresh all pivot tables. All you have to do is just use below-mentioned code.
Dim PC As PivotCache
For Each PC In ActiveWorkbook.PivotCachesPC
Above code will refresh all the pivot tables from your active worksheet.You can also assign this macro to a button to use in a single click.
If you have some specific pivot tables which you want to update then you can use below VBA code.
Change the name of the pivot tables as per your workbook.
And, if you want to update these custom pivot tables every time when you open a workbook, change the name of the macro to auto_open.
Refreshing all the pivot tables at the same time can save your ton of time. You don’t need to go each pivot and then refresh it. And, with VBA you can also refresh selected pivot tables.
From all the methods which we have above, you can anyone which you think is a perfect for you. Or, you can use all of them according to the situation you have.
I hope tip will help you to get better at Excel.
Now, tell me one thing. Have you ever tried to update all the pivot tables at once? Do you have any other method to do this? Please share your views with me in the comment section, I would love to hear from you.
And, please don’t forget to share this tip with your buddies. I’m sure they will appreciate it.