Excel Sheet Compacting?

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" <[email protected]> wrote in message news:[email protected]...
> 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.