Originally Posted by pdecrocq
Reopening the worksheet more than one month later to update it, I find that the cells do not recalculate unless I edit their content (press F2 and enter, no change to cell contents). F9 or Shift-F9 produce nothing !
Another mystery ?
According to the manual you must use Ctrl-Alt-F9 to update all values. The reason you need to use Ctrl-Alt-F9 is because the function is non-volatile. You could make the function volatile, but it might cause performance issues, if you care using this INDIRECT.EXT a lot.
Hope this answers your question. For more information have a look at the manual.