automatically update the pivot table
I am using excel 2003
How can I update the pivot table automatically when I open the workboolk ? Thanks -- eva cheng |
automatically update the pivot table
eva...
you can try with this link http://www.vbaexpress.com/kb/getarticle.php?kb_id=80 "eva cheng" wrote: I am using excel 2003 How can I update the pivot table automatically when I open the workboolk ? Thanks -- eva cheng |
Quote:
step 2: choose options step 3: check on "refresh on open". Please revert back, if you need further assistance. all the best |
automatically update the pivot table
eva cheng wrote:
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 -- Message posted via OfficeKB.com http://www.officekb.com/Uwe/Forums.a...excel/201005/1 |
All times are GMT +1. The time now is 06:01 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com