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

    File size with pivot tables (excel 2000)

    I have a "Master" pivot table and transaction source listing covering a set of accounts, which are the page setting. As I select one from the list and get a separate table for it, I want to move that table behind a presentation summary page. I then link or copy Table numbers onto the presentation page for that account. My question: with the drill-down enabled, am I making a new copy of the "original" Year-to-date-all-accounts" pivot table each time I copy the Pivot table tab (I copy the Master Pivot table in the workbook and rename it.) thus increasing the size of my file? I hate to do that, but I want to keep the drill down capability somewhere in the file.

    Thanks. Just getting into Pivot tables and finding them much more efficient than any other approach. But I may be taking the 'long way around on this project.

  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: File size with pivot tables (excel 2000)

    Check out this KB article

    It discusses file size and pivots
    Steve

Posting Permissions

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