My first guess is that the user has calculation set to manual. But I don't
think I've seen the cell change from a good value to an error then back to the
correct value.

But I'd check there.

If that doesn't help, maybe you could post the formula causing the trouble????

KiwiSteve wrote:

Many of my users have ocassional instances where a formula is copied
from adjacent cells and will not work until the cursor is placed in the
edit bar and the formula edit is confirmed (with no changes). Once the
'no change' edit is done, the cell value will change from VALUE to the
correct result. I have seen similiar reports of this in many groups,
but no one seems to be able to say why this is happening, they only
talk about work arounds after the problem has happened, but I would
really like to know if there is a way of preventing it. We use Excel
2003.

--

Dave Peterson