software

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?

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

quot;gregoryquot; gt; wrote in message
...
gt; When I update a range than a CSE formula is referencing, Excel
gt; takes longer
gt; than usual to calculate. Is this normal or just particular to
gt; my pc?
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

quot;Chip Pearsonquot; wrote:

gt; Array formulas take longer to calculate because they calculate as
gt; many times as there are items in the array.
gt;
gt;
gt; --
gt; Cordially,
gt; Chip Pearson
gt; Microsoft MVP - Excel
gt; Pearson Software Consulting, LLC
gt; www.cpearson.com
gt;
gt; quot;gregoryquot; gt; wrote in message
gt; ...
gt; gt; When I update a range than a CSE formula is referencing, Excel
gt; gt; takes longer
gt; gt; than usual to calculate. Is this normal or just particular to
gt; gt; my pc?
gt;
gt;
gt;