FORMULAS

  • Thread starter Thread starter Guest
  • Start date Start date
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?
 
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?
 
Make sure the wb is set to automatic calculation mode.
Tools > Options > Calculation tab.

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

Carlos
 
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.
 
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.
 
Back
Top