HOW DO FIND OUT THE SIZE OF EACH WORKSHEET WITHIN A WORKBOOK

[keyson2004]

I have a very large wotkbook 10MB and want to find out how I can reduce it
and also find out the size of each worksheet within the workbook to see if
there is anything I can do to reduce the size of each worksheet. I use many
vlookup , if formauls in the workbook

 

[Joel]

A 10MB file for Excel isn't very large, It is just Large. Excel often makes
workbooks larger than necessary. Sometimes making a small change will cause
excel to grow from a 1 MB file to a 10 MB file. It is difficult to return it
back to a smaller file when you have a lot of formulas. I been successful in
returning a workbook to a smaller size by copying each sheet one at a time to
a new workbook. This won't work if you have a lot of formulas that reference
multiple worksheets.

The key is what is really your problem. Is your problem that the workbook
is slow or take a long time to open and close? You can turn automatic
updating off to speed up the entering of a workbook. You can convert some of
your formulars to macros which will speed up operations. I don't think that
finding the SIZE of the worksheets will really solve any problems.

 

[Charles Williams]

You can find out the size of each worksheet by deleting a worksheet and
saving the workbook using a different name. Do this in turn until you only
have 1 worksheet left. The difference in the file size gives you the size of
the worksheet you just deleted.
Note that the disk size of a worksheet does not neccessarily correspond well
to the memory used by that worksheet.

But I agree with Joel that the size of a worksheet is not usually the
problem, but calculation time and memory is.

Charles
___________________________________
The Excel Calculation Site
http://www.decisionmodels.com

 

[Dave Peterson]

You could copy each worksheet to a new workbook (each one to a separate
workbook), save those workbooks, then use windows explorer to look at the size
of those new workbooks.