Home |
Search |
Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
"not enough resources available "
Why does excel crash, no warning, stating "not enough resourses avaiable to
display ...." the spreadsheets freeze, the menu bar blacks out or disappears, I cannot save and exit. I run 4 gigs ram, total allapplications running much less than that? Excel 2007 cannot handle on new 3ghz cpu machine what Excel 2002 could do on 1 gig 5 year old 1.3ghz cpu running exactly the same applications Could it have something to do with the way paging is setup in the windows XP operating system? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
"not enough resources available "
Have you tested on both versions of excel. One file or many? etc.
By any chance are you trying to get info from a large external file? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Why does excel crash, no warning, stating "not enough resourses avaiable to display ...." the spreadsheets freeze, the menu bar blacks out or disappears, I cannot save and exit. I run 4 gigs ram, total allapplications running much less than that? Excel 2007 cannot handle on new 3ghz cpu machine what Excel 2002 could do on 1 gig 5 year old 1.3ghz cpu running exactly the same applications Could it have something to do with the way paging is setup in the windows XP operating system? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
"not enough resources available "
Yes on all counts - these are the same spreadsheets (converted) we have run
for years. I have brought some forward and re-created others. Nothing really fancy, I do use color formating and fills etc. But these are 500 line 30 column spreads. I have no problem opening in 2003 and have run 50,000 line 26 column spreads in excel 2002 (with much more complicated formulas) with no problem. Have run spreadsheets in 2 and 3 simutanous excel sessions and again in 1 session, No difference, intermittently, three times a week, it all freezes and crash. I bet all open application are not more using more than 2 gig of the 4 gig ram, In summary few small ram footprint still results in "not enough resources etc".; I expected this new top of line Dell to allow for exponential improvements in productivity, instead with 2007 Excel I am dying. Dell has no solution, MS will not support OEM. Thanks for your consideration "Don Guillett" wrote: Have you tested on both versions of excel. One file or many? etc. By any chance are you trying to get info from a large external file? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Why does excel crash, no warning, stating "not enough resourses avaiable to display ...." the spreadsheets freeze, the menu bar blacks out or disappears, I cannot save and exit. I run 4 gigs ram, total allapplications running much less than that? Excel 2007 cannot handle on new 3ghz cpu machine what Excel 2002 could do on 1 gig 5 year old 1.3ghz cpu running exactly the same applications Could it have something to do with the way paging is setup in the windows XP operating system? |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
"not enough resources available "
Not that I am aware of Don, but thanks. The issue is intermittent, with no
seeming tie to when or what point of sys load triggers it. I'll keep the vigil for an answer and solution .. best regards "Don Guillett" wrote: Did you resolve this? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Yes on all counts - these are the same spreadsheets (converted) we have run for years. I have brought some forward and re-created others. Nothing really fancy, I do use color formating and fills etc. But these are 500 line 30 column spreads. I have no problem opening in 2003 and have run 50,000 line 26 column spreads in excel 2002 (with much more complicated formulas) with no problem. Have run spreadsheets in 2 and 3 simutanous excel sessions and again in 1 session, No difference, intermittently, three times a week, it all freezes and crash. I bet all open application are not more using more than 2 gig of the 4 gig ram, In summary few small ram footprint still results in "not enough resources etc".; I expected this new top of line Dell to allow for exponential improvements in productivity, instead with 2007 Excel I am dying. Dell has no solution, MS will not support OEM. Thanks for your consideration "Don Guillett" wrote: Have you tested on both versions of excel. One file or many? etc. By any chance are you trying to get info from a large external file? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Why does excel crash, no warning, stating "not enough resourses avaiable to display ...." the spreadsheets freeze, the menu bar blacks out or disappears, I cannot save and exit. I run 4 gigs ram, total allapplications running much less than that? Excel 2007 cannot handle on new 3ghz cpu machine what Excel 2002 could do on 1 gig 5 year old 1.3ghz cpu running exactly the same applications Could it have something to do with the way paging is setup in the windows XP operating system? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
"not enough resources available "
As you may recall, I brought up getting data from LARGE external files. I had this problem with a client recently. If I can help let me know -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Not that I am aware of Don, but thanks. The issue is intermittent, with no seeming tie to when or what point of sys load triggers it. I'll keep the vigil for an answer and solution .. best regards "Don Guillett" wrote: Did you resolve this? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Yes on all counts - these are the same spreadsheets (converted) we have run for years. I have brought some forward and re-created others. Nothing really fancy, I do use color formating and fills etc. But these are 500 line 30 column spreads. I have no problem opening in 2003 and have run 50,000 line 26 column spreads in excel 2002 (with much more complicated formulas) with no problem. Have run spreadsheets in 2 and 3 simutanous excel sessions and again in 1 session, No difference, intermittently, three times a week, it all freezes and crash. I bet all open application are not more using more than 2 gig of the 4 gig ram, In summary few small ram footprint still results in "not enough resources etc".; I expected this new top of line Dell to allow for exponential improvements in productivity, instead with 2007 Excel I am dying. Dell has no solution, MS will not support OEM. Thanks for your consideration "Don Guillett" wrote: Have you tested on both versions of excel. One file or many? etc. By any chance are you trying to get info from a large external file? -- Don Guillett Microsoft MVP Excel SalesAid Software "CGCPA" wrote in message ... Why does excel crash, no warning, stating "not enough resourses avaiable to display ...." the spreadsheets freeze, the menu bar blacks out or disappears, I cannot save and exit. I run 4 gigs ram, total allapplications running much less than that? Excel 2007 cannot handle on new 3ghz cpu machine what Excel 2002 could do on 1 gig 5 year old 1.3ghz cpu running exactly the same applications Could it have something to do with the way paging is setup in the windows XP operating system? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell | Excel Discussion (Misc queries) | |||
"Excel cannot complete this task with available resources" | Excel Discussion (Misc queries) | |||
"Not enough system resources to display completely" message | Excel Discussion (Misc queries) | |||
"Excel cannot complete this task with available resources" | Excel Discussion (Misc queries) | |||
Error message "Not enough system resources to display completely." | Excel Discussion (Misc queries) |