20 Ton Squirrel
New Member
- Joined
- Aug 18, 2011
- Messages
- 11
The Setup:
An Excel 2003 workbook containing 20 pivots all based on a single data range. The range is 24,000 rows by 20 columns, so naturally the workbook is getting some serious bloat.
Documentation on caches is sparse, but I read somewhere that pivot tables based on the same source can all have the same cache, evidenced in some code found here:
http://www.contextures.com/xlPivot11.html
I changed the cacheIndex on all my pivots to be based on the first cache, saved the workbook, and saw the 60Mb workbook drop to 12Mb.
The Problem:
Refreshing the pivots causes Excel to immediately seize up and crash! Am I barking up the wrong tree here?
An Excel 2003 workbook containing 20 pivots all based on a single data range. The range is 24,000 rows by 20 columns, so naturally the workbook is getting some serious bloat.
Documentation on caches is sparse, but I read somewhere that pivot tables based on the same source can all have the same cache, evidenced in some code found here:
http://www.contextures.com/xlPivot11.html
I changed the cacheIndex on all my pivots to be based on the first cache, saved the workbook, and saw the 60Mb workbook drop to 12Mb.
The Problem:
Refreshing the pivots causes Excel to immediately seize up and crash! Am I barking up the wrong tree here?
