There is an option argument in INDIRECT.EXT to choose volatility:

=INDIRECT.EXT(Reference,Volatile,A1-Style,Mode)

http://xcell05.free.fr/morefunc/engl...direct.ext.htm

I think the the embedding of the addin does not work in 2007... so you can't share the workbook without having user install Morefunc too.