Forum Discussion
175429
Oct 21, 2024Copper Contributor
How Do I Stop Pivot Tables from Sharing the Same Cache?
Hello all, I want to create multiple pivot tables/graphs on the same sheet (in both Excel service and the desktop). As I am sure you all know, when you create a second pivot table and change the ...
Patrick2788
Oct 21, 2024Silver Contributor
I get the prompt in my Excel when using the Wizard. Did you already have 1 pivot table created when you pulled up Alt +D, P ?
- 175429Oct 21, 2024Copper Contributor
Patrick2788 yes, I already had one pivot table created. Do I need to use the wizard before creating any table?
- Patrick2788Oct 21, 2024Silver ContributorNo. I tested it by first making a pivot table the usual way through the ribbon via Insert | PivotTable. The 2nd pivot table was created with the wizard.