Memory per Sheet

S

Steph

Hi all. Does anyone have a utility or know how to determine how much memory
each sheet in a workbook is responsible for? I have a workbook that is 21MB
in size. I'd like to reduce the size, but it would be easier if i knew
which sheets in particular were the memory hogs. Thanks!

-Steph
 
F

Frank Kabel

Hi Charles

now I'm interested :)
An utility to check the memory usage of an individual sheet within a
workbook (and without tricks like copying this sheet to a separate file
and getting that memory usage).

There is it <vbg>
 
D

David McRitchie

Hi Steph,
This question must be almost identical to to one that someone posted in June.,
because right after I wrote it someone asked such a question.

Save each worksheet separately to multiple workbooks (#MakeMultipleXLSfromWB)
Saveas, Save each worksheet as a separate workbook
http://www.mvps.org/dmcritchie/excel/saveas.htm
and them look in the generated subdirectory of your c:\temp\D....
to see the file sizes.
 
S

Steph

Charles & Frank,

I'm confused.....there is a utility that does that? Where? I didn't see a
link or anything to your previous posts?! Thanks!

-Steph
 
Top