ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Pivot cache (https://www.excelbanter.com/excel-discussion-misc-queries/55393-pivot-cache.html)

Kreed

Pivot cache
 
I found in "http://www.contextures.com/xlPivot11.html#Top" a program that can
use the same pivot cache for all the reports within the workbook. Two
questions: will using this program reduce the size of the overall workbook?
And is there is way to help me modify this program so that I can cache a few
reports to be used in a workbook (as opposed to one)? Many thanks (in
advance)!!


All times are GMT +1. The time now is 04:50 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com