View Single Post
  #3   Report Post  
bala_vb bala_vb is offline
Senior Member
 
Location: Hyderabad
Posts: 237
Thumbs up

Quote:
Originally Posted by eva cheng View Post
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
__________________
Thanks
Bala