Question, is there a way that I can "compact" an excel sheet, just like
access can be compacted. Reason is that I have this workbook with about
35worksheets, all pivot tables, I had to change the datasource to sql and now
the size of the sheet jumped to 500megs (it started off with 100megs). When
trying to save the sheet, it takes about 5 mins. Also there are about 45
pivot tables, none of them have the same datasource. was wondering, if
possible, maybe to save time and space, to change the source to one pivot
table but still show it as many times as I want.

Hi Justin

There is no option in Excel but look here
http://www.contextures.com/xlfaqApp.html#Unused

--
Regards Ron De Bruin
http://www.rondebruin.nl



"Justin" wrote in message ...
Question, is there a way that I can "compact" an excel sheet, just like
access can be compacted. Reason is that I have this workbook with about
35worksheets, all pivot tables, I had to change the datasource to sql and now
the size of the sheet jumped to 500megs (it started off with 100megs). When
trying to save the sheet, it takes about 5 mins. Also there are about 45
pivot tables, none of them have the same datasource. was wondering, if
possible, maybe to save time and space, to change the source to one pivot
table but still show it as many times as I want.