![]() |
If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
![]()
I have just inserted a series of 8 calculated fields using sumproduct
into a spreadsheet which references a closed workbook and have now been given the error - "Excel cannot complete this task with available resources. Choose less data or close other applications" Any bright ideas on how to make additional resources available as there are no other applications open. Any help would be appreciated BJthebear |
#2
|
|||
|
|||
![]()
Here is a link to info on memory, speed and calculation.
http://www.decisionmodels.com/index.htm Wtihout seeing your formulas it is hard to comment further. -- HTH... Jim Thomlinson "BJ&theBear" wrote: I have just inserted a series of 8 calculated fields using sumproduct into a spreadsheet which references a closed workbook and have now been given the error - "Excel cannot complete this task with available resources. Choose less data or close other applications" Any bright ideas on how to make additional resources available as there are no other applications open. Any help would be appreciated BJthebear . |
#3
|
|||
|
|||
![]()
I have to setup a template for options excel but I don't have much information about it. I have to import data from another database Is there any thing available for use or any kind of help.
|
Thread Tools | |
Display Modes | |
|
|