Results 1 to 2 of 2

Thread: Linking pivot tables

  1. #1
    Seeker robinssdawn's Avatar
    Join Date
    Nov 2017
    Posts
    7
    Articles
    0
    Excel Version
    2010

    Linking pivot tables



    Register for a FREE account, and/
    or Log in to avoid these ads!

    I have 9 pivot tables in Excel 2010 that all have the same field lists just different views of the data.

    Currently for each one, i have to go into Change Data Source to update each one. Excel 2007 had a feature in the Pivot table Wizard ( i do believe) where i could link the tables. When one is updated they ALL update.

    Obviously in 2010, this does not exist and i really need it to.

    I don't know how to use the slicer and not sure if that will answer my issue anyway.

    also, i tried copying a pivot table and pasting as Paste Link but then the field list was not attached to it nor are any of the Pivot table options in the Ribbon.

    How can i tie all of these tables together so when i update the first one, they all update?

  2. #2
    Conjurer alansidman's Avatar
    Join Date
    Oct 2018
    Location
    Steamboat Springs
    Posts
    171
    Articles
    0
    Excel Version
    2019
    What happens when you update the data source and click on the refresh button? Does that not update each of the pivot tables? What am I missing here. Perhaps you should upload your workbook for analysis. Be sure to sanitize it for confidential data.

Posting Permissions

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