Why would a formula stop working in an Excell spreadsheet?
 

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.

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

"Number one Giraffe" <Number one wrote in
message ...
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.

ToolsOptionsCalculation 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

"Number one Giraffe" <Number one wrote in
message ...
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.

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


"Number one Giraffe" wrote:

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.

Why would a formula stop working in an Excell spreadsheet?
 

Thanks,
Works great now.
--
Daryl


"Manish Bajpai" wrote:

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


"Number one Giraffe" wrote:

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.