I've got a fairly large spreadsheet, with many formulas. Although the AutoCalc is set, the sheet won't Calculate unless I press the F9 key. Many of the formulas in the worksheet are dependant on the =Now() formula auto-updating when the time changes.
I need the cells to update when the time changes (i.e. when the "=NOW()" changes), but the time ("=NOW()") won't change unless I press F9.
How can I make the sheet automaticly press F9 at certain time intervals, when the time intervals on the sheet won't change?
Thanks.....
I need the cells to update when the time changes (i.e. when the "=NOW()" changes), but the time ("=NOW()") won't change unless I press F9.
How can I make the sheet automaticly press F9 at certain time intervals, when the time intervals on the sheet won't change?
Thanks.....