Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refreshing Pivot Tables
I have one set of data and several pivot tables created using this data all
in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refreshing Pivot Tables
If you created the pivot tables by copying an existing pivot table,
they're based on the same pivot cache, and that's what you're refreshing. To create a different pivot cache for a pivot table: Right-click a cell in the pivot table, and choose PivotTable Wizard Click the Back button For the data range, change the last row so it's one row up. For example, if the current range is A1:M500, change it to A1:M499 Click Finish The pivot table will now have a separate pivot cache. Go back into the PivotTable Wizard, and change the data range to its previous setting, and click Finish. Lisa wrote: I have one set of data and several pivot tables created using this data all in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Refreshing Pivot Tables
Aha! Thank you very much!
"Debra Dalgleish" wrote: If you created the pivot tables by copying an existing pivot table, they're based on the same pivot cache, and that's what you're refreshing. To create a different pivot cache for a pivot table: Right-click a cell in the pivot table, and choose PivotTable Wizard Click the Back button For the data range, change the last row so it's one row up. For example, if the current range is A1:M500, change it to A1:M499 Click Finish The pivot table will now have a separate pivot cache. Go back into the PivotTable Wizard, and change the data range to its previous setting, and click Finish. Lisa wrote: I have one set of data and several pivot tables created using this data all in the same workbook (each pivot table has its own tab) When refreshing the pivot tables I need to be able to refresh only one pivot table at a time, and the problem is that sometimes several pivot tables are updated after refreshing only one. This is needed because some of the pivot tables contain information that is updated only quarterly, yearly, etc. How do I ensure that all the pivot tables are set up correctly so that only one is refreshed at a time? -- Debra Dalgleish Contextures http://www.contextures.com/tiptech.html |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Refreshing Pivot Tables in a Shared Workbook | Excel Worksheet Functions | |||
refreshing pivot tables with a macro | Excel Discussion (Misc queries) | |||
pivot tables not refreshing correctly | Excel Worksheet Functions | |||
Refreshing multiple pivot tables | Excel Discussion (Misc queries) | |||
Pivot Tables are Automatically refreshing | Excel Discussion (Misc queries) |