Formulas suddenly stopped working??

[Rich_B]

Hi

Could somebody please help me with the following problem:

I have a spreadsheet with some simple IF, AND, OR etc. formulas on one tab which I have not used for a couple of weeks. I have been working on another tab with it's own separate formulas.

I have today gone back to the first tab and all the formulas are no longer working. It's as if they've been deactivated somehow. The formulas in the other tab still work fine.

How can I get the formulas in the first tab working again?

Many thanks

Rich

 

[NeonRedSharpie]

What isn't working about them? Are they not updating or are they returning wrong data/errors?

 

[Rich_B]

I have resolved this now thank you. I had the recalculation setting set to manual.