+ Reply to Thread
Results 1 to 5 of 5

Change Pivot Source Data in multiple pivot tables

  1. #1
    Registered User
    Join Date
    05-17-2012
    Location
    australia
    MS-Off Ver
    Excel 2007
    Posts
    11

    Change Pivot Source Data in multiple pivot tables

    Hi All

    Any help with this would be appreciated. I have a single workbook with multiple worksheets. Each worksheet has a different pivot table displaying a different view of the data. Each pivot table uses the same source data at worksheet1.

    Each week i add new data to the end of the source data, which means that I need change the source data reference separately in each pivot table to update each pivot table view to include the new data. This is laborious as there are quite a few pivot tables.

    Was wondering if there is some way of changing the pivot table source data reference on all pivot tables at the same time.

    Thanks

  2. #2
    Registered User
    Join Date
    05-01-2014
    Location
    Brisbane, Australia
    MS-Off Ver
    Excel 2013
    Posts
    1

    Re: Change Pivot Source Data in multiple pivot tables

    Have you tried to format the source data as a table?

    i have done this with my source data and so each week when i add the new data, the pivot tables automatically refresh.

    Hope that helps!
    Last edited by jspencer12; 05-18-2014 at 09:13 PM. Reason: grammar

  3. #3
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,135

    Re: Change Pivot Source Data in multiple pivot tables

    Hi,

    An alternate way would be to select the entire columns as data source instead of just the data range. i.e, If your data source is from A1: AB2,000, select A:AB as the data source in Pivot Table. This way you don't need to change the data source in each Pivot every week.

  4. #4
    Registered User
    Join Date
    01-06-2014
    Location
    Columbus, IN
    MS-Off Ver
    2013/O365
    Posts
    41

    Re: Change Pivot Source Data in multiple pivot tables

    ^ That's what I do. PTs look at the whole range I expect to use before the computer melts or I clear out the sheet for year-end.
    -Russell

  5. #5
    Forum Guru romperstomper's Avatar
    Join Date
    11-04-2008
    Location
    A1
    MS-Off Ver
    Most
    Posts
    12,302

    Re: Change Pivot Source Data in multiple pivot tables

    Using entire columns is inefficient and unnecessary though. Using a table or a dynamic named range is better.
    Remember what the dormouse said
    Feed your head

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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