FORMULAS
 

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

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?

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?

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?

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?



.

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?

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?

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?

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?

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?