Choose ViewToolbarsExternal Data
Click the Refresh All button.

This will refresh all the pivot tables and external ranges in the workbook.

kraway wrote:
I have a large spreadsheet with many pivot table reports. I want a macro
that will update all of them with one click of the mouse.


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html