Maximum File Size

[cmandel]

Is there a maximum file size that Excel can read? I know
the max rows is 65,536, but is there a limit to the
overall file size?

 

[Bernard Liengme]

Not that I know of but your RAM (memory) does limit how much data an Excel
file can cope with.
Bernard

 

[cmandel]

Where can I find out how RAM limits the amount of data?

 

[Ken Wright]

Though depending on your version of Excel and the amount of RAM you have, the internal memory
limits that Excel has could be far lower:-

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

 

[Jean-Paul Viel]

Hi,



The maximum file size is limited by your operating system who inherited from
DOS the value 2 Gigabytes. The RAM will limit the speed to access the
information because the operating system will have to do swapping to fetch
from hard drive the information you wish to see.

 

[Ken Wright]

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