Usable memory in Excel

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Joe Clement - 02 Apr 2007 20:18 GMT

I seem to remember reading somewhere that there is a limit to the amount of
memory that Excel can use, even if you have much more RAM available is the
computer.

For example, if your computer has 512 mb of RAM, an Excel workbook might be
able to use only 50 mb (or whatever) of it.

I can't seem to find anything to confirm or refute this. Can anyone help.

I am using Excel 2003 on a Windows XP machine.

Reply to this Message

George Nicholson - 02 Apr 2007 20:34 GMT

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

As you will see, memory constraints were a much bigger issue before Excel
2003.

HTH,

>I seem to remember reading somewhere that there is a limit to the amount of
>memory that Excel can use, even if you have much more RAM available is the
[quoted text clipped - 6 lines]
>
> I am using Excel 2003 on a Windows XP machine.

Reply to this Message

Joe Clement - 04 Apr 2007 13:41 GMT

Many thanks for your info.

Many years ago I had a big Excel 97 workbook that kept growing until one day
it locked up my machine. After being told about the memory limits I split
it up into 2 workbooks. Wasn't as efficient but at least it works. Now
that I've got Excel 2003 I can again go back to building huge spreadsheets
<g>.

> http://www.decisionmodels.com/memlimitsc.htm
>
[quoted text clipped - 14 lines]
>>
>> I am using Excel 2003 on a Windows XP machine.

Reply to this Message

Rate this thread: