Date change I write and store business invoices. Every time I open an old invoice the date changes to the present day. Consequently I lose valuable information relating to the date the original invoice was written. I, and a number of friends cannot find a way to stop this happening. Please help Albert Oulton

If you are using Excel 2007 ...Open Excel ... Click the Office button ... select Open ... highlight the file you wish to open ... then at the bottom of the dialog box click the downarrow next to Open and choose "Open-Read Only".
or
Before opening your old document(s), right-click the file ... select properties ... place a check mark in the box Read-only ... Select OK. Your application should open the file in Read-Only mode and will not be able to make changes or save the file.

I remember learning how to do this through my course so am sure there is a way to turn off the auto update of the date. As I now don't have office 07 and none of the books on it could help me, have researched the poblem on the net for u.
This is what I found, hope it is helpful. As I said don't have office 07 now to try it on but hope it works for u
Good luck.
B C

It sounds like you have created your documents using a template. In many Word templates there is a DATE field that is designed to poll the computer system and apply the current date into that field.
What you need to do is change the DATE field to a CREATEDATE field to preserve the date you actually created the document on.
Just press Alt+F9 to display the field code and change DATE (or TIME) to CREATEDATE, then Alt+F9 to toggle back and then F9 to update