Formula's stop working

[Matt Riddler]

I have a budget sheet in an excel document (excel 2002) for a tv show that I
am working on, but all of the formulas have stopped working. I have checked
through all of the cells & the formula's are still there, but just not
totalling.
They are just plain c1+c2=c3, no macro's involved.

I have already had to get IT Support to restore the file twice.
Can anybody help.

Thanks,

Matt

 

[Frank Kabel]

Hi Matt
1. check 'Tools - Options - View'. Uncheck 'Formulas'

2. check if your cells are not formated as 'Text' (Goto 'Format -
cells')

 

[Norman Harker]

Hi Matt!

Try:
Tools > Options > Calculation
Place check in Automatic

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

 

[JE McGimpsey]

try Tool/Options/Calculation and make sure the Automatic option button
is selected.