Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
|
|||
|
|||
Quote:
step 2: choose options step 3: check on "refresh on open". Please revert back, if you need further assistance. all the best
__________________
Thanks Bala |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Pivot Table Update | Excel Discussion (Misc queries) | |||
Pivot table does not automatically update when underlying data cha | New Users to Excel | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
VLOOK-pivot table expanding want to update vlook automatically | Excel Worksheet Functions | |||
automatically update pivot tables when dynamic named range is expa | Excel Discussion (Misc queries) |