Refresh All Pivot Tables at once [Quick Tip]

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).RefreshAll to 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.

More Quick Tips:

• 10 Must have Excel Shortcuts
• What are Pivot Table Report Filters & How to use them?
• Compare Data using Row Differences
• Format Multiple Sheets with Grouping Option
• More Quick Tips