CSE formulas?
 

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?

CSE formulas?
 

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

"gregory" wrote in message
...
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?

CSE formulas?
 

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

"Chip Pearson" wrote:

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

"gregory" wrote in message
...
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?