Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disbale the shared PivotTable cache (Excel 2007)
Dear Experts,
whenever I create a new pivot report based on data in the same workbook. The report is based the shared PivotTable cache. This is unwanted as certain manipulations (e.g. un-/grouping) do apply to all pivot reports in the workbook. ). How can I stop this behavior? Thanks and regards ANDI |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Disbale the shared PivotTable cache (Excel 2007)
Hi ANDI,
The 'old' PivotTable wizard still exists in Excel 2007 but to use it you will need to customise the Quick Access Toolbar to add the button 'PivotTable and PivotChart Wizard' from the 'Commands Not in Ribbon' This will give you the option to create a new Pivot Table cache Best, Bert ANDI schreef: Dear Experts, whenever I create a new pivot report based on data in the same workbook. The report is based the shared PivotTable cache. This is unwanted as certain manipulations (e.g. un-/grouping) do apply to all pivot reports in the workbook. ). How can I stop this behavior? Thanks and regards ANDI |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
PivotTable Rank - Excel 2007 | Excel Worksheet Functions | |||
Excel 2007 PivotTable Question | Excel Worksheet Functions | |||
Excel 2007: Pivot sharing same cache? | Excel Discussion (Misc queries) | |||
Enable/Disbale Macro on opening Excel file | Excel Discussion (Misc queries) | |||
Excel 2007 PivotTable and Chart | Excel Discussion (Misc queries) |