is =INDIRECT a volatile function ?

[Chris Davison]

Evening all,

I know =NOW and =TODAY are termed volatile and I read recently that =ROW and =COLUMN are to a certain extent

is =INDIRECT also volatile ?

I recently posted an =INDIRECT with two =ROW functions solution which was copied to nearly 4000 rows but when I hit F9, it still just took a milli-second to calculate

I've been using INDIRECT a lot, and hadn't thought if it might affect performance....

thanks
Chris

 

[Aladin Akyurek]

On 2002-05-08 15:38, Chris Davison wrote:
Evening all,

I know =NOW and =TODAY are termed volatile and I read recently that =ROW and =COLUMN are to a certain extent

is =INDIRECT also volatile ?

I recently posted an =INDIRECT with two =ROW functions solution which was copied to nearly 4000 rows but when I hit F9, it still just took a milli-second to calculate

I've been using INDIRECT a lot, and hadn't thought if it might affect performance....

thanks
Chris
/board/images/smiles/icon_smile.gif

Yes, INDIRECT is volatile. Too many of them will cause expanding recalc times.

 

[Mark W.]

See http://www.decisionmodels.com/calcsecretsi.htm