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!
Pentium 3, Win.NT 4