| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Displaying when workbook was last updated
User Defined Function.................UDF
Gord On Fri, 19 Jun 2009 06:21:19 -0700, Sapper wrote: Many thanks to Bob and Gord. I have still no idea what a UDF is but and how the syntax is worked out but I got the result that I wanted. "Sapper" wrote: 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
