Memory per Sheet
 

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

Memory per Sheet
 

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

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

Memory per Sheet
 

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

Memory per Sheet
 

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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

Memory per Sheet
 

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