Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
How do I get the formula bar in excel 2003 | Excel Discussion (Misc queries) | |||
How do I prevent Excel from plotting a cell w/ a formula as a "ze. | Charts and Charting in Excel | |||
Need excel formula to display 28.50hrs in HRS & MINS? | Excel Worksheet Functions | |||
Suddenly Excel can't calculate formula!!! | Excel Worksheet Functions |