Results 1 to 7 of 7
  1. #1
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    pivot table (excel 2003)

    Hi all,

    Is there a way you can link multiple data sources files to the same pivot table if these source data files are identical in structure but have different names and you are doing that because you do not want to create the same pivot table for each file.

    TIA
    dubdub
    TIA
    dubdub

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table (excel 2003)

    Do you want to be able to switch from one data source to another, or do you want to combine all the data sources in one pivot table?

  3. #3
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table (excel 2003)

    switch.

    regards,
    dubdub
    TIA
    dubdub

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table (excel 2003)

    Click anywhere in the pivot table.
    Select Data | Pivot Table and Pivot Chart Report from the menu bar, or Pivot Table | Wizard from the Pivot Table toolbar.
    Click < Back.
    Specify a different data source.
    Click Finish.

  5. #5
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table (excel 2003)

    thanks HansV.

    you encourage me to ask how about if you want to join two data sources.

    regards,
    dubdub
    TIA
    dubdub

  6. #6
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: pivot table (excel 2003)

    That depends on how exactly you want to join them.

    One option is to create a worksheet in which you paste the two data sources below each other (with only one set of column headers), and use the combined range as data source.
    Another option is to use "Multiple consolidation ranges" in the first step of the Pivot Table Wizard. This assumes that each of the source tables already has a pivot table-like structure.

  7. #7
    3 Star Lounger
    Join Date
    Jul 2005
    Location
    Bahrain
    Posts
    373
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: pivot table (excel 2003)

    thanks again.

    dubdub
    TIA
    dubdub

Posting Permissions

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