Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
Hi,
I am using Excel 2007. In one cell, I entered the following formula: =Now() After I typed in the formula and hit <Enter, my cell displayed the current time when I hit <Enter. I was hoping that as time went by, the value in my cell would be constantly updated so as to reflect the current time. Currently, the only way I can get the value in my cell to update is to go to Formulas | Calculation Group and select "Calculate Now". Is there anyway I can make my cell update automatically without having to do this? Thanks in advance, Paul -- Paul Kraemer |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Auto update a linked Cell | Links and Linking in Excel | |||
Auto Update Text Box Cell Reference | Excel Discussion (Misc queries) | |||
auto-hide rows, cell format (# and @), update cell refs, shade cel | Excel Discussion (Misc queries) | |||
How to auto update a cell with a current date | Excel Discussion (Misc queries) | |||
Auto update of cell information | Excel Discussion (Misc queries) |