General discussion

Locked

XL97 - Add the "last edited" time in a

By Chouf ·
I'd like to know if it's possible to add in a cell, the last time the spreadsheet was updated by someone. I know there's the "&time" stuff that can be put in the header, but that's not whats the user want. He'd like, in a cell, to have the last timethe workbook was updated and of course that this info changes as soon as it's edited. I've foudn the =TODAY()function, but it only displays the current date and time, which is not great as it changes each time you open the sheet.

Any idea ?

Config : XL97 Pro SP2

This conversation is currently closed to new comments.

3 total posts (Page 1 of 1)  
| Thread display: Collapse - | Expand +

All Comments

Collapse -

XL97 - Add the "last edited" time in a

by DKlippert In reply to XL97 - Add the "last edi ...

Check out Chip Pearson's information:

http://www.cpearson.com/excel/docprop.htm

Collapse -

XL97 - Add the "last edited" time in a

by Chouf In reply to XL97 - Add the "last edi ...

thanks a lot mate. First class answer ! ;-)

Collapse -

XL97 - Add the "last edited" time in a

by Chouf In reply to XL97 - Add the "last edi ...

This question was closed by the author

Back to Software Forum
3 total posts (Page 1 of 1)  

Related Discussions

Related Forums