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 ?

eva cheng

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

you can try with this link

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