LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,819
Default Excel 2007 Changes date stamp on Save As

Humm, can't replicate that here. Original keeps the old date, Saved As
copy has today's date. Perhaps you are looking at Modified Date stamp?

Williams wrote:

I opened an old excel file with a date stamp of 1/8/2008. I closed it
immediately then rechecked the time stamp ...it still read 1/8/2008. Then I
opened the file with the date stamp of 1/8/2008, immediately chose File, Save
as and renamed the file. After I closed the new file, I checked the date
stamp of both files...they both reflect the current date. This is happening
with all files in Excel 2007, and it is not just on my workstation. A few
co-workers are the ones that brought this to my attention. Please help.

"Sheeloo" wrote:


Original file stamp should not change...

If you open a file in Excel then look at the timestamp it will show you the
current date & time but if you close it without saving timestamp reverts back
to the original value...

Test this with any file...

Then test again after SAVE AS...
Also verify that your file does not have an auto-save macro. To do that just
open it and close after sometime and check the timestamp..

Also you may test with some other file and see whether this is happening
with a particular file or all files.


"Williams" wrote:


When I open a file that I previously created in Excel, then I immediately
choose Save As to make a copy of the file the date stamp on the original and
new file
reflect the current date. Is there a new service release that prevents this
from happening? I do not want the date on the original file to change. The
original file does not contain links to other files.




 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2007 Changes date stamp on Save As Williams Excel Discussion (Misc queries) 3 October 7th 08 06:14 PM
product date stamp file save Robert Loxley Excel Discussion (Misc queries) 12 November 13th 06 02:48 PM
How can you save a spreadsheet with a date stamp. kenny Excel Worksheet Functions 1 May 15th 06 05:19 PM
how do I fix the date stamp in excel? [email protected] Excel Worksheet Functions 5 March 5th 06 03:08 PM
Date stamp spreadsheet in excel to remind me of completion date Big fella Excel Worksheet Functions 1 October 18th 05 04:10 PM


All times are GMT +1. The time now is 05:42 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"