Hi,

NOW and other volatile functions don't just change when the file is
opened, they change every time the sheet is recalculated.

Take a look here for a workaround.
http://www.mcgimpsey.com/excel/timestamp.html

HTH
Martin


"f16pilot71" wrote in message
...
When I insert the NOW function in my worksheet, it updates whenever I open
it. I only want the function to work when I hit "save" or update a cell
in
the worksheet, so that the date/time indicate the last time someone
reviewed/changed it, not the last time it was simply opened.