Results 1 to 4 of 4
  1. #1
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Can multiple worksheets be linked to a Pivot Table (Excel 97 SR-2)

    I got a request for help that deals with Pivot Table. That is out of my area of knowlege, so I figured I would ask the ones that seem to know all....

    Can more than 4 worksheets be linked into a single pivot table successfully?

    The situation is 15-20 workbook tabs that relate to outside legal vendors. Would like to create pivot table(s) that summarizes these tables by client (Metro Transit, ES, etc.) being charged the Outside Legal expense.

    Thanks,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

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

    Re: Can multiple worksheets be linked to a Pivot Table (Excel 97 SR-2)

    I don't have Excel 97 any more, but in Excel 2002 there does not seem to be a limit to the number of worksheets that can contribute to a pivot table

  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Can multiple worksheets be linked to a Pivot Table (Excel 97 SR-2)

    I just did 32 sheets without any problems in XL97.

    I think you are limited to 4 "Custom" page fields" but if you let excel create the page fields you get 1 for each sheet.

    Steve

  4. #4
    3 Star Lounger
    Join Date
    May 2002
    Location
    Mpls, Minnesota, USA
    Posts
    271
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Can multiple worksheets be linked to a Pivot Table (Excel 97 SR-2)

    Hans and Steve,

    Thanks for the fast replys. I passed the information on to the user. I think I may check out Pivot Tables so maybe I can help them with future questions.

    Thanks again,
    Chuck
    Chuck Reimer
    I'm from the Government and I'm here to help...

Posting Permissions

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