Forum Discussion
Why are My Pivot Table Settings Linked?
Hi there. So I am creating a report and have a group of pivot tables that rely on custom date grouping to look at week-over-week changes. When I create a new pivot table with the same data sourc...
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.