Hi,

In Excel 2007, there is a button to "Refresh All" under Pivot Table Tools
Options. When you click on that button, all pivot tables should update.
Not sure of whether there is a "Refresh all" in Excel 2003

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"Eric" wrote in message
...
I believe there is a way to create a button to refresh multiple pivot
tables
within the same file, but I can't seem to figure it out.

I'm creating a model and would like less sophisticated users to be able to
use it. I would therefore like to create a simple button to refresh all
pivot tables on the first sheet of the workbook.

Any help is greatly appreciated!!