| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Excel Can't Complete This Task with Available Resources.
Greetings! I was running an Excel Macro using Excel 2007 Home and Student.
The program ran normally for 4 hours retrieving data from the internet using the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My machine has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4 hours, I saw the following message: "(X) Excel cannot complete this task with available resources. Choose less data or close other applications." In 3 years of running these macros, I had never seen this problem before. At the time of this problem, System Information reported the following: Installed Physical Memory: 1GB Total Physical Memory: 997 MB Available Physical Memory: 350 MB Total Virtual Memory 1.21 GB Page File Space 1.27 GB At the time of the problem, COMPUTER reports that the C Drive (on which Excel resides) has 37.3 GB free of 67.4 GB. Three Excel workbooks were open. The largest of these is 12,856 KB. The other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone know what might have caused this problem? Could it just have been a fluke? Any and all suggestions and comments are most welcome. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Can't Complete This Task with Available Resources.
I haven't seen this with Excel 2007 but I had it many times with Excel 2003.
When Excel uses memory, it maxes out at about 1.8gigs - i had 8gigs available. I understand this is true only for 32bit machines. I suspect that its the issue you have. I'm also told that Excel 2007 on a 64bit machine does not hjave this limitation. "MichaelDavid" wrote: Greetings! I was running an Excel Macro using Excel 2007 Home and Student. The program ran normally for 4 hours retrieving data from the internet using the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My machine has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4 hours, I saw the following message: "(X) Excel cannot complete this task with available resources. Choose less data or close other applications." In 3 years of running these macros, I had never seen this problem before. At the time of this problem, System Information reported the following: Installed Physical Memory: 1GB Total Physical Memory: 997 MB Available Physical Memory: 350 MB Total Virtual Memory 1.21 GB Page File Space 1.27 GB At the time of the problem, COMPUTER reports that the C Drive (on which Excel resides) has 37.3 GB free of 67.4 GB. Three Excel workbooks were open. The largest of these is 12,856 KB. The other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone know what might have caused this problem? Could it just have been a fluke? Any and all suggestions and comments are most welcome. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Can't Complete This Task with Available Resources.
Looks like your workbooks, though on the largish size, are not excessive. So
it sounds like your macro is creating memory bloat or leakage. What does your macro do, eg create lots of objects or IE instances without destroying them as you go. Regards, Peter T "MichaelDavid" wrote in message ... Greetings! I was running an Excel Macro using Excel 2007 Home and Student. The program ran normally for 4 hours retrieving data from the internet using the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My machine has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4 hours, I saw the following message: "(X) Excel cannot complete this task with available resources. Choose less data or close other applications." In 3 years of running these macros, I had never seen this problem before. At the time of this problem, System Information reported the following: Installed Physical Memory: 1GB Total Physical Memory: 997 MB Available Physical Memory: 350 MB Total Virtual Memory 1.21 GB Page File Space 1.27 GB At the time of the problem, COMPUTER reports that the C Drive (on which Excel resides) has 37.3 GB free of 67.4 GB. Three Excel workbooks were open. The largest of these is 12,856 KB. The other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone know what might have caused this problem? Could it just have been a fluke? Any and all suggestions and comments are most welcome. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Can't Complete This Task with Available Resources.
Greetings! Thanks for the info on insufficient memory problems. I revised my
macro programs to generate much smaller worksheets, and the problem has not re-occurred. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick "Patrick Molloy" wrote: I haven't seen this with Excel 2007 but I had it many times with Excel 2003. When Excel uses memory, it maxes out at about 1.8gigs - i had 8gigs available. I understand this is true only for 32bit machines. I suspect that its the issue you have. I'm also told that Excel 2007 on a 64bit machine does not hjave this limitation. "MichaelDavid" wrote: Greetings! I was running an Excel Macro using Excel 2007 Home and Student. The program ran normally for 4 hours retrieving data from the internet using the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My machine has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4 hours, I saw the following message: "(X) Excel cannot complete this task with available resources. Choose less data or close other applications." In 3 years of running these macros, I had never seen this problem before. At the time of this problem, System Information reported the following: Installed Physical Memory: 1GB Total Physical Memory: 997 MB Available Physical Memory: 350 MB Total Virtual Memory 1.21 GB Page File Space 1.27 GB At the time of the problem, COMPUTER reports that the C Drive (on which Excel resides) has 37.3 GB free of 67.4 GB. Three Excel workbooks were open. The largest of these is 12,856 KB. The other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone know what might have caused this problem? Could it just have been a fluke? Any and all suggestions and comments are most welcome. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
|
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Excel Can't Complete This Task with Available Resources.
Hi Peter
Greetings! My macro created a workbook with tons of worksheets. I revised the macro programs instead create a workbook with just two worksheets. It would be nice to have all the worksheets, but I rarely looked at them. They were an intermediate result of the program. Fortunately, with the smaller workbook, the problem has not re-occurred. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick "Peter T" wrote: Looks like your workbooks, though on the largish size, are not excessive. So it sounds like your macro is creating memory bloat or leakage. What does your macro do, eg create lots of objects or IE instances without destroying them as you go. Regards, Peter T "MichaelDavid" wrote in message ... Greetings! I was running an Excel Macro using Excel 2007 Home and Student. The program ran normally for 4 hours retrieving data from the internet using the macro program Macro Scheduler 11.06 and Internet Explorer 7.0. My machine has Windows Vista with Service Pack 1. It has 1 GB RAM. After about 4 hours, I saw the following message: "(X) Excel cannot complete this task with available resources. Choose less data or close other applications." In 3 years of running these macros, I had never seen this problem before. At the time of this problem, System Information reported the following: Installed Physical Memory: 1GB Total Physical Memory: 997 MB Available Physical Memory: 350 MB Total Virtual Memory 1.21 GB Page File Space 1.27 GB At the time of the problem, COMPUTER reports that the C Drive (on which Excel resides) has 37.3 GB free of 67.4 GB. Three Excel workbooks were open. The largest of these is 12,856 KB. The other 2 workbooks are 1866 and 292 KB in size respectively. Does anyone know what might have caused this problem? Could it just have been a fluke? Any and all suggestions and comments are most welcome. -- May you have a most blessed day! Sincerely, Michael Fitzpatrick -- May you have a most blessed day! Sincerely, Michael Fitzpatrick |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel cannot complete this task with availible resources | Setting up and Configuration of Excel | |||
| Excel cannot complete this task with available resources | Excel Worksheet Functions | |||
| Excel cannot complete this task with available resources. | Excel Worksheet Functions | |||
| Excel cannot complete this task with available resources | Excel Programming | |||
| Excel cannot complete this task with available resources. | Excel Discussion (Misc queries) | |||
Linear Mode
