S
SouthtxDayna
Why would a formula suddenly quit working and how do you fix it?
C
CarlosAntenna
It happens "AutoMagically" 
You need to post more details.
Carlos
You need to post more details.
Carlos
S
SouthtxDayna
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?
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?
R
RagDyer
Try:
<Tools> <Options> <Calculation> tab,
And make sure "Automatic" *is* checked.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
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?
<Tools> <Options> <Calculation> tab,
And make sure "Automatic" *is* checked.
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
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?
J
Jason Morin
Make sure the wb is set to automatic calculation mode.
Tools > Options > Calculation tab.
HTH
Jason
Atlanta, GA
Tools > Options > Calculation tab.
HTH
Jason
Atlanta, GA
P
Peo Sjoblom
tools>options>calculation check automatic
Regards,
Peo Sjoblom
Regards,
Peo Sjoblom
C
CarlosAntenna
Does it recalculate if you press F9 ? You may need to turn on automatic
calculation. Tools>Options>Calculation>Automatic.
Carlos
calculation. Tools>Options>Calculation>Automatic.
Carlos
S
SouthtxDayna
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.
I'm a bit curious how it still would have wroked up until today and then quit
but, regardless, it's fixed now.
R
RagDyer
Check out this old post:
http://tinyurl.com/3sf3g
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
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.
http://tinyurl.com/3sf3g
--
HTH,
RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================
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.
S
Silva
Peo Sjoblom said: