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.
Bookmarks