| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Automatic Refresh Date and Time
Good Day,
Can you help me into my problem using Excel 2000, I just want is when I'd Put =Now() in cell A1 it will aumatic running without pressing F9 Key. Thanks in Advance!!! @ Advance Happy New Year!!! ^_^ -jaeson |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Automatic Refresh Date and Time
That formula only calculates when excel recalculates.
You could use an ontime macro that runs every so often to force recalculation. But there's nothing built into excel that will do what you want. jaeson wrote: Good Day, Can you help me into my problem using Excel 2000, I just want is when I'd Put =Now() in cell A1 it will aumatic running without pressing F9 Key. Thanks in Advance!!! @ Advance Happy New Year!!! ^_^ -jaeson -- Dave Peterson |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I display data refresh date and time | Excel Worksheet Functions | |||
| Automatic Time and Date | Excel Worksheet Functions | |||
| How can I 'Enable Automatic Refresh' for Query Refresh by default | Setting up and Configuration of Excel | |||
| Query Refresh-Enable Automatic Refresh Dialogue Box | Excel Discussion (Misc queries) | |||
| Timing of automatic query refresh and macro pivot table refresh | Excel Programming | |||
Linear Mode
