How do I write an Excel formula that re-calculates every 24 hrs?

[Guest]

I need to write a formula that will recalculate itself every 24 hours without
any intervention from humans. I have no idea how to do this.

 

[Bob Phillips]

What would change that would cause it to need to recalculate, the date,
time?

You probably need a timed event, using the OnTime function
(http://www.cpearson.com/excel/ontime.htm) , or use the windows scheduler to
launch an Excel workbook with a workbook open event that does the biz and
then shuts down.

Probably need good error trapping as well, and take some positive action .

 

[Guest]

I need for the workbook to recalculate a long formula. It will be 29 - 31
cells long, and is calculating sales goals each day. I am not there on Sat
and Sun so I need Excel to do it for me on those days.
So did you mean that I should use the "on Time" function and an auto
republish function as well(i.e., windows scheduler)?
I am self taught so i don't know all of this fancy stuff...
btw...Thanks for your suggestion!

 

[Bob Phillips]

No, I am suggesting or, OnTime or Sceduler.