Why would a formula stop working in an Excell spreadsheet?

  • Thread starter Number one Giraffe
  • Start date
N

Number one Giraffe

We are using a spreadsheet that has been functioning correctly for several
months, suddenly the cell containing the formula ceased to function.

Has anyone experienced this and is there a remedy??

Thank you.
 
P

Paul B

Check tools, options, calculation, and check automatic if it is not checked
--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
N

Niek Otten

Tools>Options>Calculation tab, Check Automatic

If this is not the solution, post again in this thread, but with more
details, please: Formula, addresses, values, results, etc

--
Kind regards,

Niek Otten

Microsoft MVP - Excel
 
M

Manish Bajpai

Yes, don't worry. Just follow the steps as under:

Click - Tools on Bar on top of Excel window,
Select - "Options",
Go to "Calculation" tab and
Just ensure that in Calculation Box "Automatic" is checked.

Thanks,

Manish Bajpai
 
D

Daryl

Thanks,
Works great now.
--
Daryl


Manish Bajpai said:
Yes, don't worry. Just follow the steps as under:

Click - Tools on Bar on top of Excel window,
Select - "Options",
Go to "Calculation" tab and
Just ensure that in Calculation Box "Automatic" is checked.

Thanks,

Manish Bajpai
Click to expand...
 
Top