LAST TIME MODIFIED TO SHOW ON WORKSHEET

[Hilary_Arnold]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I want to show automatically the date last modified on a worksheet. I know I can see it as a header on page layout view BUT is it possible to either show header in normal view of insert a function to show date last modified?

Many thanks.

 

[JE McGimpsey]

Version: 2008
Operating System: Mac OS X 10.5 (Leopard)

I want to show automatically the date last modified on a worksheet. I know I
can see it as a header on page layout view BUT is it possible to either show
header in normal view of insert a function to show date last modified?

One way is to use circular references:

http://mcgimpsey.com/excel/timestamp.html