The empty rows don't take up any space unless you've had something in them
previously (causing the high file size) - in any case you can't change the
number of rows or columns in a workbook. If your workbook doesn't really
have data of 50MB then create a new workbook and copy the information from
the old one into the new one - this should remove the "empty" cells that are
taking up file space.


"Mike" wrote in message
...
My computer slows to a crawl or locks up because the workbook is over 50
MEG.
I want to try to fix this problem by limiting the number of rows tha Excel
2007 uses or in other words make the end of the sheet less then 1,000,000.
I
have over 1 MEG of RAM and am using Windows Vista.