Help Excel Has stoped working!!!

[tonylpcs@yahoo.co.uk]

Hi Everyone,

I have a big problem,
My excel spreedsheet has stoped working.
It has several formulars in it and has worked fine up until yesterday, then it just stoped.
None of the formulars now calculate.
they will start working again if i click n the cell with the formular in it then click the tick box but i cant do this for every formular on the page.

anyone know whats causing this?

thanks

Tony

 

[VoG]

Try Edit > Replace

Replace what: =

Replace with: =

click OK.

 

[moonfish]

It could be that your calculations are set to manual. Does the spreadsheet update if you press F9?

To change this setting in Excel 2007, go to Excel Options > Formulas > Calculation Options > Workbook Calculation and set it to automatic.

 

[tonylpcs@yahoo.co.uk]

thank you,

you are quite right somehow it had set to manual.

all fixed now.

thank you

Tony