View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Andi Andi is offline
external usenet poster
 
Posts: 25
Default 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