Excel 2002 Refresh Pivot Table Automatically

[~Dave~]

Does the pivot table refresh itself automatically in Excel 2002?

 

[Dave Peterson]

Nope. You still have to refresh it manually. (Same with xl2003.)

 

[Ed Ferrero]

Hi Dave,

If a Pivot Table is based on an external data source, you can set it to
refresh whenever the workbook is opened. Hint: an external data source can
also be an Excel workbook.

Ed Ferrero
http://edferrero.m6.net