On Fri, 27 Nov 2009 19:43:23 +0000 Came this utterance formulated by bill purvis to my mailbox:
> On Friday 27 November 2009, Andreas Saeger wrote: > > bill purvis wrote: > > > I am working on a multi-sheet parts list spreadsheet and it would > > > be really useful if I could automatically insert the date of the > > > most change at the bottom of each sheet. I can see that I can > > > enter the'current' date, but I'd really like the date at which any > > > of the sheets were last modified. At present I have a hidden field > > > on sheet1 and copy this to all the relevant cells, but then I have > > > to unhide the cell, update the content, and re-hide it each time I > > > change something. Is there such a function - I couldn't see it in > > > the help list. > > > > > > Bill > > > > Type the address or name of the cell into the name box left of the > > formula bar. > > Then type into the formula bar: =NOW() F9 Enter Enter > > > No good! I want to be able to open the spreadsheet and see when it was > last modified - NOW() gets updated when you load a SS, otherwise it > would be the answer. Thanks anyway! > I understand that you are not looking for the date and time of the last sheet-recalculation. But are you looking for the date when the file was last saved, when a formula was last modified or when content was last updated? -- Michael All shall be well, and all shall be well, and all manner of things shall be well - Julian of Norwich 1342 - 1416 --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
