GazTheHat

I have a s/sheet in excel 2003 that i use to record my in/out/lunch times. This has been working great for a year.

Coincidental? I opened in excel 97 and since then it doesn't seem to work properly.

None of the calculations work. Enter a later leaving time, nothing changes on hours worked.

BUT......the calculations take place when you save the document.

Any ideas??

bob269

Try looking in Tools/Options/Calculation.

Not sure if the settings are in 97 but they are in the XP office version. It needs to be set to Automatic.

GazTheHat

Perfect!!

That is it. It was on manual. Changed to automatic and works a treat.

Many thanks.

bob269

No problem mate, i think back in 97 large spreadsheets used to cripple pc's when calculating so the default was manual with the view of doing the calculations as few times as possible.

GazTheHat

That would probably explain it, as it has a sheet for each week. Around 2 years worth. Thanks again.