RE: Displaying when workbook was last updated

Tech-Archive recommends: Fix windows errors by optimizing your registry

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 work*** 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


.

Quantcast