You need code to do this,

One way to do it, copy this code into the this 'ThisWorkbook' window in the
VBA editor.

Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As
Boolean)
Sheet1.Range("A1").Value = Date
Sheet1.Range("A2").Value = Time
End Sub

This will put the date saved into A1 and the time saved into A2. To have the
date and time in one cell use

Sheet1.Range("A1").Value = Now

To do this, hit Alt and F11 together to display the VB editor, on the left
of the new window you should see 'This Workbook' Click this to open the
window, copy and paste, hit Alt and F11 again to close the VB editor, save
the file.
Adjust the cell references to suit and format the cells to suit as well,
Regards,
Alan.
"Colin Macleod" wrote in message
...
I want one of the cells on my worksheet to show the date the file was last
saved on - and to update automatically.
What's the best way to do this?
Thanks

Colin

--