Excel 2002 Refresh Pivot Table Automatically

  • Thread starter Thread starter ~Dave~
  • Start date Start date
Nope. You still have to refresh it manually. (Same with xl2003.)
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Pivot table report invalid 0
Automatically update pivot table when switching to sheet that thepivot table is in 4
Pivot Table Help! 1
Pivot Table Source file 2
How to base a pivot table on another pivot table? 3
Refresh CubeFields for existing Pivot Table on OLAP cube 1
PERFORM ACTION ON HITTING ENTER 1
Export Pivot table 1

Back
Top