Pivot Tables are an integral part of Excel based reports. So it is no surprise that many of create multiple pivot reports in one Excel workbook.
So when the underlying data changes, we often spend time refreshing individual pivot tables. Today, I want to share a quick tip about how to refresh all pivot tables at once.
Refreshing All Pivot Tables in One Click:
- Go to Data Ribbon
- Click on Refresh All button (or press CTRL+ALT+F5)
- That is all!
This simple step can update all pivot tables and data connections in one go. What a time saver this is.
One line Macro to Refresh All Pivot Tables
If you want to use VBA (Macros) to refresh your pivot tables, the code is equally silly. Just add this line:
ActiveWorkbook.RefreshAll- or use
Workbooks(1).RefreshAllto refresh Pivots & Connections in first workbook
Do you use RefreshAll?
Ever since I learned about Refresh All, I have been using it in all my reports & dashboards. In fact, I even use the ActiveWorkbook.RefreshAll statement in my macro-enabled reports to automatically refresh all pivot tables during report generation.
What about you? Do you use Refresh All feature? What other Pivot Table Tricks you know? Please share your experience & tips using comments.
2 Responses to “Best of Chandoo.org – 2013”
sir i want your autograph
How many times during the year did I click on most of the pages there to learn something new? Thank you Chandoo!