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

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.

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 .

--
HTH

Bob Phillips

"heather" wrote in message
...
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.

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" wrote:

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 .

--
HTH

Bob Phillips

"heather" wrote in message
...
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.

No, I am suggesting or, OnTime or Sceduler.

--
HTH

Bob Phillips

"heather" wrote in message
...
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" wrote:

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
..

--
HTH

Bob Phillips

"heather" wrote in message
...
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.