Are you doing it at the far left row NUMBERS
If desired, send your file to my address below along with this msg and
a clear explanation of what you want and before/after examples.


--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"jabe813" wrote in message
...
Do you happen to know what to do if the below does not work?

I am using Excel 2003. The file is 7MB and needs to be smaller.

I followed your directions below.

When I right click the short cut menu options is "Delete Row"

When I do that it does not ask to 'delete entire row'.
I get an hour glass and in the bottom left corner I get "Calculating
Cells:
X%"
When it reaches 100% I still have 65536 rows and then columns that go to
IV

Please help :-)


"Gord Dibben" wrote:

Apologies for the lack of direction about re-setting the used range on a
sheet.

The reason you have such a large used range is the copying of formulas
down and
across far more rows and columns than you may reasonably need.

To reset the used range, go to the bottom of your actual data.

Select the row below and SHIFT + End + DownArrow

EditDeleteEntire Row.

Do same for all columns to the right of your data.

Do this on all sheets.

Now......important part.........Save/Close and reopen.

What is size of workbook now?

To address the original problem, which is having formulas :just in case"
you may
want to read up on "Dynamic Ranges" at Debra Dalgleish's site.

http://www.contextures.on.ca/xlNames01.html#Dynamic

Formulas can be entered that will look at only the used range.


Gord

On Wed, 27 Feb 2008 11:23:03 -0800, JoAnn

wrote:

The file size is 20,073KB.

What do you mean by "reset the used range on all sheets"? I haven't
done
that since I didn't know I had to and don't know how to do it. I
couldn't
find anything in Help on it. Please explain what I have to do.

The only ranges I have set are the sections I'm using for calculations.
But
when I format or add a formula to a cell/column/row, I generally copy it
down
so it exists in all worksheet rows/columns (I use the keyboard sequence
Ctrl-Shift-DownArrow to select them then paste my formula or formatting
change). That's when I noticed that I had a lot of rows. Could that be
causing a problem?

Thanks for all your help with this!
JoAnn