+ Reply to Thread
Results 1 to 3 of 3

Multiple Pivot Tables, Same Data Source

  1. #1
    Registered User
    Join Date
    10-30-2008
    Location
    Boston
    Posts
    1

    Multiple Pivot Tables, Same Data Source

    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

  2. #2
    Registered User
    Join Date
    02-19-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Multiple Pivot Tables, Same Data Source

    Bump for good measure, its the same reason I am here...

  3. #3
    Registered User
    Join Date
    02-19-2014
    Location
    Australia
    MS-Off Ver
    Excel 2007
    Posts
    21

    Re: Multiple Pivot Tables, Same Data Source

    I have a solution for those people still looking....

    http://www.mrexcel.com/forum/excel-q...ml#post3741349

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1