PDA

View Full Version : Solved: Reduce size of Pivot Table Workbook



alu
11-18-2008, 09:38 AM
Hi all, XP sp2, Excel 2003

I have a workbook with 6 worksheets:


A normal worksheet with 500 rows and A-BB columns
A standard chart drawn off the work sheet
2 x pivot tables drawing data off the main data worksheet
2 x pivot charts drawing data off the pivot tablesThe problem is the file size is around 7MB.

I have checked to make sure there are no erronious values in empty cells and resized the print area to include only the data.

There are no images in it.

Any idead? Thansk in advance all

alu

MikeO
11-18-2008, 12:43 PM
Give this a try:

http://www.vbaexpress.com/kb/getarticle.php?kb_id=83