Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Excessive Pivot Tables? (2000/SR1)

    What would happen if you put multiple pivot tables on a worksheet? For example, if I create a pivot table that displays the number of male voters with their ages, then copy that pivot table and paste it in the columns to the right so I can compare female voters with their ages. (I want to see male to female voters). I now have two pivot tables on a worksheet. Now, suppose I do this 5 or 6 times comparing black, white, asian, indian, hispanic, etc.
    Thanks,
    Caroline in lala-land

  2. #2
    3 Star Lounger
    Join Date
    Jan 2001
    Location
    Adelaide, South Australia, Australia
    Posts
    387
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excessive Pivot Tables? (2000/SR1)

    I do this frequently without any trouble. I guess if the PTs are enormous you might at least slow things up somewhat. You could put ethnicity as a Page field and do a Copy / Paste Special Values and Formats for each field.

  3. #3
    2 Star Lounger
    Join Date
    Sep 2001
    Location
    California
    Posts
    106
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Excessive Pivot Tables? (2000/SR1)

    Thanks for the info. I was just trying to figure out why a spreadsheet suddenly isn't allowing me to open it. I can import the individual worksheets into Access (to retrieve the data) but the spreadsheet just won't open. I thought it might be the pivot tables.
    Thanks,
    Caroline in lala-land

Posting Permissions

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