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 data in that table, it also changes the data in the first pivot table. And so on and so forth. 

How do I get the pivot tables to stop “sharing” the same data so that each pivot table is independent?

Fyi, the “Alt+D+P” to bring up the legacy Pivot Table Wizard does not work for me.

When bring it up, I never got the below prompt to separate the source data.

Any advice?

​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 data in that table, it also changes the data in the first pivot table. And so on and so forth.  How do I get the pivot tables to stop “sharing” the same data so that each pivot table is independent? Fyi, the “Alt+D+P” to bring up the legacy Pivot Table Wizard does not work for me. When bring it up, I never got the below prompt to separate the source data. Any advice?   Read More

​