Glad it helped sort out things over there.
The feedback is appreciated.

.. The calculation updating was somehow set to manual.

Excel sets the calc mode based on the mode for the 1st book opened in the
session. If the 1st book's mode happen to be manual, then any subsequent book
opened in the same session will be on manual calc mode, irrespective of their
earlier saved modes. Whenever/if in doubt, just do the quick check on the
calc mode (Tools Options Calc tab).
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---