Header date changes when emailed

[3rdGen]

I have xp on my home computer and at the office we have vista (going to upgrade both soon!) When i have a spread sheet with a date in the upper right of the Header box, such as June 30, 2011, and email it from my home computer to the office one, the date in the header changes when the sheet is opened! And it changed it to a previous date. How can i prevent the date from changing. Thanks,
3rdGen

 

[imsonbi]

Why dont you just key in the date, so it wont change whenever you open the file.

 

[3rdGen]

Each month i do key in the date in the header box on the sheet at my home office, but when it's emailed and then opened up at the main office the date is different??? On both systems we have excel 2007

 

[imsonbi]

If you use AUTO-TEXT, it will change once you open up the file.

To check just click on date and see if a Grey Color highlighted the date, otherwise check the VBA, see if any autoexec part.