insufficient memory

  • Thread starter Thread starter John Nelson
  • Start date Start date
J

John Nelson

When opening excel spreadsheets the system randomly will
display the following message: "Microsoft excel cannot
open or save any more documents because there is not
enough memory or diskspace"

Memory nor diskspace is a issue. The only way you can
correct the condition is to restart the computer. Then
you can open the spreadsheet in question. After you
close it you cannot open it again until you restart again.
It does this with random spreadsheets, no always the same
one. System is a Dell Optiplex P4, 256K Ram, and plenty
of disk space. Excel is 2002 version.

Any suggestions would be helpful.

Thanks, John Nelson
 
Hi John

I think this may be the problem I had earlier this week.
The problem was that excell has a buffer of 80meg for
formulas and once you exceed that limit and after you
exceed that limit you seem to be able to save but not open
the book again. Do you have more than about 40,000
formula's in your workbook?

Also when I posted a question these are the links that
people supplied me with

This is a 'code cleaner' which copies everything out of
your workbook and back in again when I did it to mine it
shrunk by around 3%
http://www.appspro.com/utilities/Cleaner.asp

These are general read sites and with your problem
definately worth a read

http://www.decisionmodels.com/calcsecrets.htm
http://www.decisionmodels.com/memlimitsc.htm

hope this helps
Jase
(e-mail address removed)
 
Back
Top