In one of the Excel newsgroups last week, someone asked how they could update several pivot tables at the same time. They were tired of selecting each pivot table separately, and clicking the Refresh button.

In an Excel workbook you can refresh all the pivot tables and queries if you click the Refresh All button. [...]