+ Reply to Thread
Results 1 to 2 of 2

Multiple Pivot tables using single Pivotcache

  1. #1
    Registered User
    Join Date

    Multiple Pivot tables using single Pivotcache

    Hello all,

    I have 8 pivot tables that all use the same source data which is in the same workbook as the pivot tables. I have a very slow network, and i am told that all the pivot tables use a different pivotcache, but it is possible to make them all use the same pivotcache, will will reduce the file size and hence make it quicker to load over the network.

    Is it possible to use a single pivotcache, and will it reduce the file size?

    And of course how do i go about doing it?

    Thank you very much for your help.

  2. #2
    Forum Expert
    Join Date
    MS-Off Ver
    XL2003 / 2007 / 2010
    Hi, and welcome to the board
    as far as I know, after you have created a PT using a list, when creating more PT's based on the sam list XL asks you if you want to use the same cache.
    Just answer " yes" and do the same for other PT's.

    You will find more info here http://www.contextures.com/xlPivot11.html


+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1