Maximum Excel file size

S

StuBradley

I created an Excel file (62MB) yesterday on this PC and was able to save it to the hard drive. When I attempt to open it today, it causes an error “Not enough memoryâ€

The PC has 1.7GHz processor w/ 524MB RAM. Is this not enough power to open this file? Why did it let me save the file yesterday and not open it today? Any other ideas as to what the issue may be

When looking at the Processes tab in Task Manager, the Memory Usage is approx. 105MB with nothing running. It seems that there should be enough memory to open the Excel file

Thanks a bunch for your help
 
K

Ken Wright

Excel has it's own internal memory limits that are not necessarily linked to
your physical memory:-

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

--
Regards
Ken....................... Microsoft MVP - Excel
Sys Spec - Win XP Pro / XL 97/00/02/03

----------------------------------------------------------------------------
It's easier to beg forgiveness than ask permission :)
----------------------------------------------------------------------------



StuBradley said:
I created an Excel file (62MB) yesterday on this PC and was able to save it to
Click to expand...
the hard drive. When I attempt to open it today, it causes an error "Not enough
memory"
The PC has 1.7GHz processor w/ 524MB RAM. Is this not enough power to open
Click to expand...
this file? Why did it let me save the file yesterday and not open it today?
Any other ideas as to what the issue may be?
When looking at the Processes tab in Task Manager, the Memory Usage is approx.
Click to expand...
105MB with nothing running. It seems that there should be enough memory to open
the Excel file.
 
Top