On Saturday 28 November 2009, Brian Barker wrote: > ... > >>>>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. > You're right - I hadn't realized that F9 did that! I had to look up what F9 did and assumed it simply ran the calculate pass again.
> No: I didn't know about this either. And it may not serve your > purpose, of course. > It's certainly not quite what I was looking for. I wanted something that would do the update without me having to remember to do it! As I've now found what I consider to be a good solution, it's academic, but it may prove useful at some later point. > I trust this helps. > Thanks for taking the trouble to explain! > Brian Barker > Bill -- +---------------------------------------+ | Bill Purvis, Model Engineer | | email: [email protected] | +---------------------------------------+ --------------------------------------------------------------------- To unsubscribe, e-mail: [email protected] For additional commands, e-mail: [email protected]
