Formulas no longer working...

[thelawns]

I have been using a spreadsheet i designed for a stock system for nearl
2 years now. Its been updated and changed here and there constantly eve
since... although i haven't made any changes at all in the last week o
two. I use the sheet weekly, to show the IN/OUT movements of stock fo
the whole week.

Now the problem is, i came to it yesterday to update it for th
suppliers stocks, and the formulas have stopped working. All of them
They only update if i click the Save icon. Whats happened?

My virus definitions are up to date, and have done system scans both i
Safe Mode and Normal mode and nothing comes up there... I am usin
Office XP with Excel 2002 SP3 and Win 2k with SP4...

This is such an important sheet. I save each weeks sheet seperatly, an
have tried changing those, but they don't work either... This i
completely random and out of the blue! HELP
!!!!!11

 

[Guest]

Hi

Go to Tools / Options / Calculation and make sure it's set to automatic

 

[thelawns]

Andy,

You sir, are an absolute star...

Why the hell has that been switched to Manual, no one else uses thi
sheet... is there a bug going round or something??

:mad

 

[Guest]

This setting is determined by the first workbook you open in the Excel
session. It means that whichever was the first one you opened today must
have calculation set to manual - and that then determines its status for the
rest of the books you open in that session.

 

[Myrna Larson]

The setting is application-wide and is determined by the first workbook that
you open. If you have another workbook which is set to manual, and you open
that workbook first, then open the workbook in question, the latter "inherits"
the manual setting.