automatically update the pivot table

[eva cheng]

I am using excel 2003

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

Thanks

 

[reza]

eva...

you can try with this link

http://www.vbaexpress.com/kb/getarticle.php?kb_id=80

 

[sidm via OfficeKB.com]

I am using excel 2003

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

Thanks

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