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...
By default Excel uses the same pivot cache. You need to create a new pivot cache.
Hi Detlef_Lewin - thanks for the response. What I'm looking for is how to not share caches for the same data source in 365.
I'd prefer not to do the trick of adding one extra row of data to manually create separate caches, because this is a weekly report that will have manually updated data - the idea is all pivots have a data source of columns A:S and all pivots get refreshed once.
All other fixes, such as opening the pivot table wizard or creating a new table rather than copy and pasting, do not seem to work in 365.
