Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Any insight into cause of Autofilter buttons to stop working? | Excel Discussion (Misc queries) | |||
Creating a check mark box | Setting up and Configuration of Excel | |||
Excell only displays the formula, not the results | Excel Discussion (Misc queries) | |||
Excel formula not working | Excel Discussion (Misc queries) | |||
What formula do I use to link worksheets together within one spre. | Excel Worksheet Functions |