Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Pivot Tbles (2000)

    I use them pivot tables alot on a daily basis to summarize data I collect. Each time I create a new pivot table the document grows and grows. Would you know of a more efficient way to summarize data?

    Thanks again

    Aunt Linda

  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 Tbles (2000)

    You can Base multiple pivot tables on the same data and reuse the CACHE (see for example How to optimize PivotTable performance in Excel 2000, which discusses ways to reduce size in files with pivot tables)

    Steve

  3. #3
    5 Star Lounger
    Join Date
    Jan 2001
    Location
    Fontana, California, USA
    Posts
    625
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Pivot Tbles (2000)

    Hey Steve -

    Perfect - thanks alot.

    Aunt Linda

Posting Permissions

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