You need to have a macro or a UDF. Try the below UDF

In any cell type the formula
=GetProperties("Last Save Time")

Function GetProperties(strType As String) As String
GetProperties = ThisWorkbook.BuiltinDocumentProperties(strType)
End Function


If this post helps click Yes
---------------
Jacob Skaria


"Fordbfilm" wrote:

Does anyone know how to automatically enter the last save date on Excel 2007
without creating a macro?