Pivot Tables interacting

Question

I have a large workbook with several pivot tables. Two of them seem to be interacting with each other for some reason. The source data in the workbook is an 11,000 line table, with one column containing dates. I have seven Pivot Tables all pulling from this source. So far this issue only looks like it is affecting two tables. My row labels are from the date column. I am trying to group the dates by weeks (group>days>7). That works fine on table A, but then when I do the same to table B, Table A ungroups. If I regroup Table A, table B ungroups.

I have seen unexplained errors with Pivot Tables and very large source data, but I really can't reduce the source data any more than I have.

Does anyone have any suggestions?

Thanks in advance for your help!

Answer 1

Hi,

This is happening because both Pivot Tables are using the same cache memory. After creating the first Pivot Table, create the others by press Alt+D+P (rather than Insert > Pivot Table).

Answer 2

You are welcome.

Answer 3

Perfect, thank you.