Automatic Refresh Date and Time

J

jaeson

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
 
D

Dave Peterson

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Scatter chart does not refresh: HELP 2
Compare shorter date range against longer date range 2
Date Time decimal value help please 1
truncate date; nix the time component 5
Can I add a formula or function to Vlookup? 1
Macros to convert Data into date format and then plot in graph 7
Worksheet_Change Event 5
Add Current date and time when pressing a command button 2

Top