MrExcel Publishing
Your One Stop for Excel Tips & Solutions

Not Enough Memory


Posted by SA on July 25, 2001 4:31 AM

I created a spreadsheet, about 30 rows by 20 columns, with most of the cells containing simple formulae (dates and logic).
It was finished, but then someone thought it would be a good idea to copy and paste the formulae into all the cells, that is, down to row 65,000! So now the file is 72 Mb and I can't open it in Excel...I get a warning 'Not enough memory'. I've tried it on a more powerful PC (2Gb), I've compressed it, tried opening it in other applications, etc. but nothing works.
I just need to delete out the extra formulae, either by opening the spreadsheet (how do I do that??) or by doing some other operation on it. Any ideas will be appreciated!
Thanks.

Excel 2000
Pentium 3, Win.NT 4


Posted by Dax on July 25, 2001 5:14 AM

If the person who added the formulas managed to paste them down to row 65536 then they should be able to open it (you wouldn't be able to do it in the first place unless you had sufficient resources).

The other thing you could try is to maximise the memory you have. Firstly, open Excel and make sure there are no add-ins in memory (Tools, Add-ins and uncheck everything in the list). Also, make sure that there are no hidden workbooks open (e.g. Personal.xls) by choosing Window, Unhide if it's available. Finally, you could increase the size of your Virtual memory in Control Panel, System, Performance tab, and click the Change button in the VM section to as large as you can. You may not be able to do this and might have to ask a kind person with administrator access to change it for you.

Good luck,
Dax.

Posted by ART on July 25, 2001 7:03 AM

make sure you are within the Excel limits 65k rows and 256 cols