Quote:
Originally Posted by eva cheng
I am using excel 2003
How can I update the pivot table automatically when I open the workboolk ?
Thanks
--
eva cheng
|
steps 1: right click on pivot table
step 2: choose options
step 3: check on "refresh on open".
Please revert back, if you need further assistance.
all the best