Make named formula volatile ?

[Jaafar Tribak]

Hi.

I have defined a named formula namely HasComment which returns TRUE if the cell has a comment and which refers to the following XML function :
=GET.CELL(46)
When I enter the named formula in a cell it works but it is not volatile .
I have tried linking it to the Now() Function as follows :
=OR(GET.CELL(46),NOW()*0)
But it is still not volatile and I still have to select the cell and press F2 to update it.

Any thoughts ?

 

[Jaafar Tribak]

"why is that the ROWS Function seems to force an update while Now doesn't ? They are both volatile though."

ROWS doesn't force an update.
The recalc only happens when one of the precedent cells is changed. Since the argument of ROWS is 1:65536, every cell on the sheet is a precedent cell. COUNTA(1:65536) or SUM(1:65536) would work as well as ROWS, except that putting them in a cell would cause a circular reference
The reason for using ROWS is that it allows a circular reference without causing an error.

Thanks for the explanation Mike.