Look he
http://www.contextures.com/xlfaqApp.html#unused
--
Kind regards,
Niek Otten
Microsoft MVP - Excel
"Castell" wrote in message ...
| 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.
|