View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Date modified changes when file not saved

This is normal.

When you open a workbook the modified date changes to current.

If you close the workbook with no changes, the modofied date will revert to last
modified date.

Open Windows Explorer and find a workbook and note the modified date,

Now open that workbook and ViewRefresh in Windows Explorer.

Date will change to current.

Close the workbook and ViewRefresh in WE.

Note date changes back to original.


Gord Dibben MS Excel MVP

On Thu, 27 Dec 2007 13:06:23 -0800, BAC wrote:

XP Pro; Office 2003

I'm not sure this is the correct place for this post, but since it's only
happening to my Excel workbooks I thought I'd statr here..


When I open Excel workbooks and then close them without making changes and
without saving (in fact I do not even get the prompt to save), the system
last date modified changes to the current date/time.

The autosave option in the Tools- Options menu is unchecked.

What else might cause this to happen and how can I prevent it? As best I can
tell this is only happening on my Excel workbooks.