Forum Discussion
Why are My Pivot Table Settings Linked?
IMHO, the easiest way to avoid such effect is to add data to data model creating PivotTable. Even if you don't use data model directly.
Hi SergeiBaklan - interesting, I will look into that as I have never used data models in Excel before!
At a quick glance, I am wondering if the file location would be an issue. It looks to me like data models rely on external data sources, and due to how this report will be shared, accessed and manipulated, it is vital that the data is locally stored within the file.
Would that create an issue for data models or would you recommend I continue looking into this option and learn data models?
Thanks!
Oops, I see you are on Mac. Not sure how and if all mentioned here functionality (data model, PowerPivot Wizard) is supported for Excel on Mac.
You may load into data model and work with internal data (tables, ranges) only. Data model will be saved within Excel file (as well as PivotTable cache if you din't uncheck this option), nothing special required to share the file.
As a minimum and as far as you don't use calculated fields you may know nothing about the data model to work with Pivot Tables based on it, except the option "Add data to data model" creating the Pivot table.
Attached is a small sample with 4 PivotTables (same source table), first two are cached, second two are on data model. You may play with them to see the difference.