Incorrect cell value. To recalculate, I need Ctrl-Alt-F9 (F9 doesn't work)

[Richard McC]

I have a 2003 Excel spreadsheet in which a single cell has calculated to an incorrect value. Not a rounding error or bad formula or anything like that.

If I press Ctrl-Alt-F9, the cell recalculates to the correct value.

Automatic calculation is ON.

I can also make it recalculate by changing the value in a precedent cell and then changing it back, or Edit=>Replace "=" with "="

I am keen to see a solution that makes this error NOT HAPPEN, rather than relying on a workaround. This is because the spreadsheet is used by many different users in many organisations, and is very important to them (it calculates final money entitlements for staff exiting their employment).

Does anyone know what might be going on? I have searched the Microsoft (and this) forum in vain.

Richard

[Richard McC]

By the way, I can't post the file. I received it as an email attachment from a user. If I save the file to my PC, the cell is calculated correctly when I open it!

[JosephP]

what is the formula?

[Richard McC]

The formula is
Cell F9 is-

=(F2<=effect_cess)*IF(F8=0,0,IF(F3="","",MAX(days_pa*((DATEDIF(F2,F3+1,"m")+DATEDIF(F2,F3+1,"md")/30-(F6/30.4375))/12),0)))

I know that there is nothing wrong with the formula. It's just that in one copy of the spreadsheet that I have been sent by a user, the value is incorrect until the sheet is forced to recalculate, when the correct value appears. Sorry about the delay in answering - I'm in Australia.