| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
automatically update date
The formulas =now() and =today() in two of our worksheets no longer work.
They used to automatically update the date when the worksheet was opened. The same formulas work in other worksheets. Any idea why they are no longer working. We want the date to automatically update to that day's date whenever the worksheet is opened. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Automatically update a cell with a date based on anther cells date | Excel Discussion (Misc queries) | |||
| Update DAte Automatically | Excel Worksheet Functions | |||
| Have date automatically update each time I open the spreadsheet | Excel Discussion (Misc queries) | |||
| How do I get the date to automatically update | Excel Worksheet Functions | |||
| Automatically enter date and time but only update once. | New Users to Excel | |||
Threaded Mode
