View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Charles Williams Charles Williams is offline
external usenet poster
 
Posts: 968
Default HOW DO FIND OUT THE SIZE OF EACH WORKSHEET WITHIN A WORKBOOK

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

"Joel" wrote in message
...
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.

"keyson2004" wrote:

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