View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default Memory per Sheet

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