How do you get functions to update
Posted by Bob Elliott on June 21, 2001 9:59 AM
I am an excel newbie.
I am revising a program at work and I don't know how to get certain functions to update. There are two functions in particular.
The first is in a cell. The line is NOW() and it is supposed to give the current date and time. The thing is it only updates when the spreadsheet calcualtes. How to you get it to update real-time?
I wrote a macro that will write the filename to a cell. Here is the code:
this_file = ActiveWorkbook.Name
ActiveCell.FormulaR1C1 = this_file
The thing is if I save the file to a different name the cell will only update when I run the macro. how do I get it to update automatically?
Thanks for your help.