Results 1 to 5 of 5
  1. #1
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot table question (Excel 2003)

    My preferred method has been to create a pivot table, then use the ctrl key to drag a new tab and change the pivot table in the new tab around for a different view of the report. On one such set, I grouped row element vendors to higher levels. Now, I think I see that on the other pivot tables as well: they don't seem to be as I left them. Is it correct to say that the grouping is being replicated on those other worksheets, even though I don't want that to happen? Is the solution to create new PTs each time? Thanks

  2. #2
    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: Pivot table question (Excel 2003)

    If I understand what you are saying, I think you must create separate pivot tables and ensure that they have separate caches.

    Steve

  3. #3
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table question (Excel 2003)

    Ok, thanks. Would disabling drilldown help keep file size down in that situation, or that doesn't really affect ultimate file size?

  4. #4
    2 Star Lounger
    Join Date
    Feb 2001
    Posts
    163
    Thanks
    2
    Thanked 0 Times in 0 Posts

    Re: Pivot table question (Excel 2003)

    Have you tried blocking the pivot table, then copying and pasting? I do this quite frequently and this method allows me to change one of the fields in the copied version without affecting the original. Sometimes for small pivot tables I copy and paste on the same sheet, other times if the pivot table is larger, I paste onto a new sheet.
    eg. for a small one, I want to see costs for all accounts, new accounts and old accounts. New and old should add up to all. I put the three pivots on the same page and can print a copy of the results. If I change branches on all 3, I can still get the information I need without worrying that changes to one Pivot table will affect the others.

  5. #5
    5 Star Lounger
    Join Date
    May 2001
    Location
    Philadelphia, Pennsylvania
    Posts
    676
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot table question (Excel 2003)

    By blocking I assume you mean Select/Entire Table and then Copy/ paste it somewhere. Sounds like what I want to do. I'll give it a test. Thanks.

Posting Permissions

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