| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying when workbook was last updated
Hi
I am using excel 2003. I want to show when a workbook was last updated because several people access the data, which can only updated by one authorised person. I used the formula (straight from the book) ......= This workbook lasted updated: "& TEXT(NOW( ), "mm/dd/yy/ hh:mm") The book says that the NOW function will only update when I save or recalculate, but it updates every time that the worksheet is open. The user then believes that the data is up to date when that may not be the case. Can you help please Thank you |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Display "Last updated date" for the Workbook (without using a macr | Excel Worksheet Functions | |||
| The workbook containts one or more links that cannot be updated? | Setting up and Configuration of Excel | |||
| workbook contains one or more links that cannot be updated | Excel Discussion (Misc queries) | |||
| XL2003SP2: This workbook contains one or more links that cannot be updated. | Setting up and Configuration of Excel | |||
| Run Macro(save workbook) after cell updated | New Users to Excel | |||
Threaded Mode
