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.
5 Responses to “Show more of your workbook on screens [quick tip]”
In 2013 you can also add to the QAT the hidden command "Toggle Full Screen View".
Instead of using the shortcut CTRL+F1, I prefer just to double-click one of the tab names (ie double-click the "Home" text on the Home tab) to enable the Ribbon Outline view. To return to the normal Ribbon state, just double-click your mouse again!
press Ctrl+Shift+F1, you will get a full screen
Instead of Ctrl + F1, I use Ctrl + Shift + F1 (Excel 2016)
Alt W E sequence for full screen
ESC to get back