Microsoft KB Archive/26726

Recovering Memory from Unused Cells in Excel for Windows PSS ID Number: Q26726 Article last modified on 03-30-1993 PSS database name: W_eXceL

2.00 2.01 2.10 3.00

WINDOWS

Summary:

When you press CTRL+END to see the end of a worksheet, the cell that is selected seems to be too far down. If you attempt to delete the cells, the error message “Not Enough Memory” occurs.

To recover the memory used by these cells, do the following:


 * 1) Select the extra rows and columns that you do not use, and choose Clear from the Edit menu.
 * 2) In the Edit Clear dialog box, choose All.
 * 3) Save the worksheet, close it, then reopen it.

More Information:

Microsoft Excel allocates memory for the cell table when it loads a sheet, so you need to close and reload the sheet to recover the memory from the cleared cells. If this operation still gives you the “Not Enough Memory” message, try clearing just the extra rows, then clear the extra columns.

If CTRL+END still selects a cell too far down, there may be formulas or named references that refer to the extra cells. To clear these cells, do the following:


 * 1) Select the extra rows.
 * 2) Choose Delete from the Edit menu.
 * 3) Save the sheet, close it, then reopen it.
 * 4) Repeat this process for the extra columns as well.

You need to close and reload the sheet so Microsoft Excel can rebuild the cell table at load time and recover memory from the unused cells.

Additional reference words: 2.0 2.00 2.01 2.1 2.10 3.0 3.00

Copyright Microsoft Corporation 1993.