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

1. Open the workbook in Microsoft Excel.
2. Click on the "File" tab in the top left corner of the screen.
3. Click on "Info" in the left-hand menu.
4. Under "Related People", you will see the size of the workbook in MB.
5. Click on "Show All Properties" at the bottom of the page.
6. Under "Document Properties", click on "Advanced Properties".
7. Click on the "Statistics" tab.
8. Here, you will see the size of each worksheet within the workbook.

To reduce the size of the workbook, you can try the following:

1. Remove any unnecessary data or formatting from the workbook.
2. Use Excel's built-in tools to compress images and reduce file size.
3. Use formulas and functions that are more efficient and require less memory, such as
   Code:

   INDEX/MATCH

   instead of
   Code:

   VLOOKUP

   .
4. Split the workbook into smaller files if possible.
5. Save the workbook in a different file format, such as CSV or XLSB, which can reduce file size.

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

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

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.



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

--

Dave Peterson

I have had this problem. A common cause of a bloated workbook is the creation of a lot of empty rows at the bottom of one sheet. For example a reformat that selects all 100,000+ rows in a column might do this.

My solution: Go to each worksheet. Go to the last desired row (you can even add a buffer. Select all cells or all rows beneath that and delete the rows. Often when you get to the offending sheet you get a pop-up warning that there is not enough memory, but you can continue as long as you agree that the "undo" won't be possible. In a recent case after I cleaned up the offending worksheet, my file shrank from 40MB to 0.276MB (an excel 2007 file).

This was much faster than trying to keep resaving the 40MB file after a sheet is deleted.