Excel - automatically update the pivot table

Asked By eva cheng on 25-May-10 02:14 AM
I am using excel 2003

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

Thanks
--
eva cheng




reza replied to eva cheng on 25-May-10 03:30 AM
eva...

you can try with this link

http://www.vbaexpress.com/kb/getarticle.php?kb_id=80
sidm via OfficeKB.com replied to eva cheng on 25-May-10 10:53 AM
Pivot Table Options> Data Options You can choose the option to update
whenever the sheet is opened

--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.aspx/ms-excel/201005/1