automatically update the pivot table

E

eva cheng

I am using excel 2003

How can I update the pivot table automatically when I open the workboolk ?

Thanks
 
S

sidm via OfficeKB.com

eva said:
I am using excel 2003

How can I update the pivot table automatically when I open the workboolk ?

Thanks
Click to expand...

Pivot Table Options> Data Options You can choose the option to update
whenever the sheet is opened
 

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

Dealing with a Pivot Table (when I don't want to) 0
Power Pivot. Yikes. 0
Turning off automatic calculation 0
Pivot Table cell values 1
How to automate update on weekly reports spreadsheet 0
Pivot Table Counting Text Data 0
Excel does not accept text format! 0
pivot won't update. 0

Top