Most of my workbooks if they do contain Pivot Tables, will contain more than one.
To have to manually refresh all of them would take too long especially if you have a number of them on a dashboard style worksheet…but…. Excel will refresh all of them at once either the REFRESH ALL button
on the Data Tab or using a keyboard shortcut.
To use the REFRESH ALL
- Click Refresh All Button
- That’s It
And as in a lot of cases with Excel there is a EVEN quicker way to accomplish this, with a keyboard shortcut- just hit CTRL+ALT+F5
So, give this tip a go, and let me know if it’s quicker for you in the comments section below.