Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum memory for Excel 2007?
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) |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum memory for Excel 2007?
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) |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
maximum memory for Excel 2007?
Thank you Roger!
I am somehow ashamed I did not see the mention of the usage in the Specification, nor in the Help file. My question is actually for my PRoject Manager who needs to manipulate the data I extract for him from SQL-Server 2005 and his machine has been crashing, with him seeing the task manager maxing out the Excel at 1GB. So I guess our help desk has to do something about his Windows Image, not Excel - well that is nice to know. Thank you once again. Sol. -- Sol If you think education is expensive - just consdier the cost of ignorance! (motto - University of Guelph, Ontario) "Sol" wrote: 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) |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I view the maximum rows in Excel 2007 (Million Rows)? | Excel Discussion (Misc queries) | |||
Excel Memory Issues | Excel Discussion (Misc queries) | |||
XL 2007 memory usage | Excel Discussion (Misc queries) | |||
Memory Leak in Excel | Excel Discussion (Misc queries) | |||
no enough memory to run excel viewer | Excel Discussion (Misc queries) |