Size of excel components

  • Thread starter Thread starter tonyr
  • Start date Start date
T

tonyr

Is there any Excel function or add-on that will display for me the size
of the components of a spreadsheet, e.g. macros, images, named ranges
unused cells, lookups etc.

I am faced with an Excel application that asks me to email
megabyte-sized spreadsheet, and I need to audit it to see where on
could cut down the size
 
Not that I'm aware.

Maybe you could remove an item, save as new name, note the size.
Reopen the original and do the next item. (lather, rinse, repeat)

You may want to use some techniques at Debra Dalgleish's site to make sure excel
knows that the last used cell of each worksheet is where you think it should be.

http://www.contextures.com/xlfaqApp.html#Unused

And you may want to look at zipping your file.

I use a program called winzip (http://www.winzip.com) that is very nice. They
offer an evaluation version if you want to try before you buy.

David McRitchie has suggested UltimateZip (http://www.ultimatezip.com) a free
program that zips and unzips.

(I've never used it, but David likes it.)
 
Back
Top