So, in Office 2007 I am having issues when a create multiple pivot tables with the same data source. I want to be able to control each independently, but instead, when I make certain changes to one table, it is effects the others as well. For example, when I change the grouping of a date field to show just quarters or years, it will make that change across all pivot tables...very frustrating..
Are they linked? How do I stop this from happening?
Thanks in advance,
-Josh
Bookmarks