trying to create separate unconnected pivot tables from my data set

nmss18

Active Member
Joined
Jun 28, 2011
Messages
312
I have a strange situation here. I have a data set and created a pivot table. I want to create a second and a third pivot table in the same sheet, from the same data set.
The problem is when I creaate the second pivot table it seems connected to the first. Specifically, I have dates in single date format. In the first pivot table I have the dates in 2 week intervals. In the second pivot table I need to see the month intervals, but when I change the format it automatically changes it in the first pivot table too.
I changed the pivot table names. I created the second pivot table in another sheet, I deleted the first pivot tbale and started from scratch. Nothing worked. I still see the same behavior.
Something must be connected but I dont know what. Any ideas would be greatly appreciated.
 

Some videos you may like

Excel Facts

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

nmss18

Active Member
Joined
Jun 28, 2011
Messages
312
Great, this worked! Thanks much (and sorry for the delayed response. Just got to this now).
 

Watch MrExcel Video

Forum statistics

Threads
1,109,540
Messages
5,529,434
Members
409,876
Latest member
Akash Yadav
Top