time date stamp upon update of sheet

[mr0everywhere]

i need to update a time stamp whenever a sheet is updated, but not opened. i do not have macro privelages. i am also a newb to excel so a walkthrough for a 2 year old would be nice

 

[Patrao]

Hi,<?xml:namespace prefix = o ns = "urn:schemas-microsoft-comfficeffice" /><o></o>
<o> </o>
Here is an idea; it’s not the most practical but without option for macros…
<o> </o>
So, in the cell were you won’t the time stamp just type:

=now()
<o> </o>
This command gives you time and date. Now the tricky bit, you need to set up the spreadsheet to calculate manually other wise every time you open the sheet it will recalculate it self.
So go to the menu Tools> Options…> Choose tab Calculation and tick Manual also make sure that Recalculate before save is ticked as well.
<o> </o>
How does it work, if you just won’t to see what you in the workbook opening and close without saving doesn’t change the time stamp. On the other hand if you make a change that you wont to save the stamp will recalculate when you save but...
<o> </o>
You need to close the workbook using the cross button in top right corner, even if you wont to save the sheet press the cross button and than press yes to save otherwise it wont work.
Or in alternative after you made your changes you can press key F9 which induces calculation and than you can close the sheet anyway you wont.
<o> </o>
Cheers
Patrao

 

[GlennUK]

... ignore this. misread post