Quote Originally Posted by Cyberdude
At this time it is hard to know what the Manual/Automatic condition state was.
Why? Doesn't Tools menu > Options > Calculation tab tell you?

Als, what's ErrMsgOvrrdeFlg? Is it a non-volatile UDF? It might not be recalculated until you encounter it somewhere and force a recalc (like opening it in the CF dialog).