Excel 2000 "Not Enough Memory" error

[George Wilson]

I have a customer trying to open an excel file that is
77MB. When trying to open the file gets a message "Not
Enough Memory" and thats it. This file was created on a
Mac OS X with Office X and it opens fine there, but has
issues with Excel 2000. Tried bumping up virtual memory
and this does not seem to help. I searched for this error
on the MSKB and the listed fixes don't seem to help.
Anyone have any ideas how to open this file successfuly on
Excel 2000?
George

 

[Ken Wright]

That's a monster file, and I've never had cause to have one anywhere near that
size. Excel has it's own internal memory limits that operate independently of
any physical memory considerations. See here for some info on that:-

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

You might want to try reducing the filesize, by perhaps enuring that the
UsedRange is not bigger than it needs to be on each sheet, and (with a backup
copy mind) on the PC it opens fine on, save it as a webpage, then save it back
as a .xls file and see if this shrinks it down.

Excels internal memory limits have pretty much doubled with each subsequent
version (Again, see the link I gave you to Charles's data)