EXCEL FILE SIZE - TABS

[MikeM]

I have a rather large excel file that has many tabs in it. I would like to
reasearch what tabs are creating it to be so large! I have a great Tool for
Powerpoint that analyses the size of each Powerpoint Slide, is there
something that would do the same thing for Excel? I do have a Macro that
will save each sheet as a seporat page, I was looking for somthing a little
simpler.
Thanks!

 

[Shane Devenshire]

Hi,

There is nothing built into Excel to do this. Someone may have written an
add-in for it but I've never heard of one.

Things to look for:
1. Graphics in your file, especially bitmap ones
2. Sheets with lots of data
3. Links to other files
4. Lots of formulas
5. Pivot tables/charts with large data sources, even external data sources.