| 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? |
| 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 | |||
Threaded Mode
