Worksheet speed with array formula

P

pkeegs

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?
 
N

Niek Otten

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

|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?
 
Top