Hi

From Microsoft's specification for XL2007
Total amount of PC memory that Excel can use
Old Limit: 1GB
New Limit: Maximum allowed by Windows

How do you know it is only using 1 GB? I am not aware of any "switch"
either in Windows or Excel to alter this.
Is your machine Dual Core?
There is a setting in round Office buttonExcel
optionsAdvancedFormulas to enable multi-threaded calculations and to
set the number of processors used, but I know of no setting to deal with
the amount of RAM.


--
Regards

Roger Govier


"Sol" wrote in message
...
Does anyone know what is the upper limit of memory allocation for
Excel 2007?

I have a machine with 4GB of RAM and at least as much virtual memory
but
..... Excel never uses more than 1GB? Hence the performance suffers.
Any
possible way to get Excel to use the available resources?

--
Sol

If you think education is expensive - just consdier the cost of
ignorance!
(motto - University of Guelph, Ontario)