FORMULAS

[Guest]

Why would a formula suddenly quit working and how do you fix it?

 

[CarlosAntenna]

It happens "AutoMagically"

You need to post more details.

Carlos

 

[Guest]

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?

 

[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?

 

[Jason Morin]

Make sure the wb is set to automatic calculation mode.
Tools > Options > Calculation tab.

HTH
Jason
Atlanta, GA

 

[Guest]

tools>options>calculation check automatic

Regards,

Peo Sjoblom

 

[CarlosAntenna]

Does it recalculate if you press F9 ? You may need to turn on automatic
calculation. Tools>Options>Calculation>Automatic.

Carlos

 

[Guest]

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]

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.

 

[Silva]

tools>options>calculation check automatic

Regards,

Peo Sjoblom