Home |
Search |
Today's Posts |
#1
|
|||
|
|||
FORMULAS
Why would a formula suddenly quit working and how do you fix it?
|
#2
|
|||
|
|||
It happens "AutoMagically" :)
You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#3
|
|||
|
|||
I set up formulas for a co-worker to calculate drive time and duration at a
particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#4
|
|||
|
|||
Try:
<Tools <Options <Calculation tab, And make sure "Automatic" *is* checked. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SouthtxDayna" wrote in message ... I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#5
|
|||
|
|||
Make sure the wb is set to automatic calculation mode.
Tools Options Calculation tab. HTH Jason Atlanta, GA -----Original Message----- I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message news:EE30F3E5-FF87-4D77-93BC- ... Why would a formula suddenly quit working and how do you fix it? . |
#6
|
|||
|
|||
toolsoptionscalculation check automatic
Regards, Peo Sjoblom "SouthtxDayna" wrote: I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#7
|
|||
|
|||
Does it recalculate if you press F9 ? You may need to turn on automatic
calculation. ToolsOptionsCalculationAutomatic. Carlos "SouthtxDayna" wrote in message ... I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#8
|
|||
|
|||
THANK YOU EVERYONE. I've learned something new and it did fix the problem.
I'm a bit curious how it still would have wroked up until today and then quit but, regardless, it's fixed now. "RagDyer" wrote: Try: <Tools <Options <Calculation tab, And make sure "Automatic" *is* checked. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SouthtxDayna" wrote in message ... I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#9
|
|||
|
|||
Check out this old post:
http://tinyurl.com/3sf3g -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SouthtxDayna" wrote in message ... THANK YOU EVERYONE. I've learned something new and it did fix the problem. I'm a bit curious how it still would have wroked up until today and then quit but, regardless, it's fixed now. "RagDyer" wrote: Try: <Tools <Options <Calculation tab, And make sure "Automatic" *is* checked. -- HTH, RD ============================================== Please keep all correspondence within the Group, so all may benefit! ============================================== "SouthtxDayna" wrote in message ... I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
#10
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
FORMULAS
"Peo Sjoblom" wrote: toolsoptionscalculation check automatic Regards, Peo Sjoblom "SouthtxDayna" wrote: I set up formulas for a co-worker to calculate drive time and duration at a particular location. It was working an hour ago and now, though the formulas are all there, it will not automatically calcualte. I don't see what's wrong to fix this. Any ideas? "CarlosAntenna" wrote: It happens "AutoMagically" :) You need to post more details. Carlos "SouthtxDayna" wrote in message ... Why would a formula suddenly quit working and how do you fix it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formulas not working | Excel Discussion (Misc queries) | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
Copying options: contents, results, formulas, etc. | New Users to Excel | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |