CSE formulas?

G

gregory

When I update a range than a CSE formula is referencing, Excel takes longer
than usual to calculate. Is this normal or just particular to my pc?
 
C

Chip Pearson

Array formulas take longer to calculate because they calculate as
many times as there are items in the array.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
G

gregory

Thanks, Chip.

I discovered another reason. The ranges I set up to be referenced were
entire columns (i.e. from rows 1-65536). I shortened the range to row 2500
and the calculation time was much faster.

Thanks again.

Gregory
 
Top