You can also open the External Data toolbar, and click the Refresh All
button, to update all the pivot tables and external data in the active
workbook.

ArcticWolf wrote:
I have a worksheet with 10 PT's in, but have to refresh each table when the
source data changes. Is there a way I can refresh all the PT on the
worksheet at once?


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