At 20:00 27/11/2009 +0000, Bill Purvis wrote:
On Friday 27 November 2009, Richard Detwiler wrote:
Bill Purvis wrote:
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.
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!
Bill: Did you actually try his suggestion? I just did, and it does
NOT update when you save and then re-open the file.
It did for me - the spreadsheet has a fair number of calculations in
it and I would expect it to recalculate when it is loaded.
For the avoidance of doubt, you may have missed the point here. If
you press F9 (or go to Tools | Cell Contents > | Recalculate) *with
the cursor in the input line*, you are offered a frozen version of
the value of NOW(). The first Enter then accepts this and the second
Enter completes the entry and returns focus to the spreadsheet. The
effect is similar to using Paste Special with Formats ticked and
Formulas not ticked: it freezes the formula into a value, so it will
never be recalculated.
No: I didn't know about this either. And it may not serve your
purpose, of course.
I trust this helps.
Brian Barker
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
