Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet speed with array formula
I have recently included an array formula (SUMPRODUCT) in my worksheet. It
works very well, doing what I wanted, but it has significantly slowed the worksheet down. I have changed the calculation to manual rather than automatic but it means that I have to remember to recalculate - frustrating. Is there anyway that I can get around this hugely reduced calculation speed? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet speed with array formula
Impossible to say without knowing your formulas; post them if you want any comments.
But yes, in general, array formulas are slow. No wonder; they do a lot of work! -- Kind regards, Niek Otten Microsoft MVP - Excel "pkeegs" wrote in message ... |I have recently included an array formula (SUMPRODUCT) in my worksheet. It | works very well, doing what I wanted, but it has significantly slowed the | worksheet down. I have changed the calculation to manual rather than | automatic but it means that I have to remember to recalculate - frustrating. | Is there anyway that I can get around this hugely reduced calculation speed? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Worksheet speed with array formula
You may want to look at this paper:
http://msdn2.microsoft.com/en-us/library/aa730921.aspx It discusses optimization for XL workbooks. It addresses issues with Xl 2007, however, many of the discussions are also relevant to earlier versions of XL. Dave -- Brevity is the soul of wit. "pkeegs" wrote: I have recently included an array formula (SUMPRODUCT) in my worksheet. It works very well, doing what I wanted, but it has significantly slowed the worksheet down. I have changed the calculation to manual rather than automatic but it means that I have to remember to recalculate - frustrating. Is there anyway that I can get around this hugely reduced calculation speed? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Efficient Array Formula Construction | Excel Discussion (Misc queries) | |||
Lookup Data in two seperate Spreadsheets | Excel Worksheet Functions | |||
Positioning Numeric Values Resulting from 6 Column Array Formula | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |