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
"Frank Kabel" wrote in message
...
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
--
Regards
Frank Kabel
Frankfurt, Germany
Charles Williams wrote:
Utility does exist ...
"Frank Kabel" wrote in message
...
Hi
don't think such an utility exists but you may check the used range
for each sheet (and correct it). See:
http://www.contextures.com/xlfaqApp.html#Unused
--
Regards
Frank Kabel
Frankfurt, Germany
Steph wrote:
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