Workbook Date

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

REM - 15 Nov 2006 21:15 GMT

why is the date on workbooks changing when I open it.

Workbook dates used to change only when changes were made.

Signature

REM

Reply to this Message

Gord Dibben - 15 Nov 2006 22:07 GMT

And that date would be reflected where?

Modified date?

When you open the file, excel always changes that modified date. If you close
without saving, it'll be changed back.

Gord Dibben MS Excel MVP

>why is the date on workbooks changing when I open it.
>
>Workbook dates used to change only when changes were made.

Reply to this Message

REM - 15 Nov 2006 22:33 GMT

Gord
Thanks.
It is the Modified Date.
It is changing even when I am not saving the file.
Regards,
REM

Signature

REM

> And that date would be reflected where?
>
[quoted text clipped - 8 lines]
> >
> >Workbook dates used to change only when changes were made.

Reply to this Message

Gord Dibben - 15 Nov 2006 22:53 GMT

It remains with the changed modified date even after closing with no changes?

Where do you see this date?

In Windows Explorer or in the Excel File>Open dialog?

Do not open the file before checking the modified date.

Gord Dibben MS Excel MVP

>Gord
>Thanks.
>It is the Modified Date.
>It is changing even when I am not saving the file.
>Regards,
>REM

Reply to this Message

REM - 15 Nov 2006 23:13 GMT

Gord

Every Excel file I worked on today was in the recovery window of Excel when
I opened it. (What do I do not to accept newer date in unchanged file?)

Yes, date changes even if not modified. Changes if opened.
I see the date in the modified date column.
The date changes in Windows Explorer
REM

Signature

REM

> It remains with the changed modified date even after closing with no changes?
>
[quoted text clipped - 12 lines]
> >Regards,
> >REM

Reply to this Message

Gord Dibben - 15 Nov 2006 23:50 GMT

Do you have any code that saves the file silently upon closing?

By "recovery window" do you mean the dialog that appears after Excel crashes and
presents you with a choice of workbooks to recover?

Gord

>Gord
>
[quoted text clipped - 5 lines]
>The date changes in Windows Explorer
> REM

Reply to this Message

REM - 16 Nov 2006 15:02 GMT

Gord

Have no clue about code "that saves the file silently." I have not done
anything proactively to change settings.

Yes I do mean the dialog. Excel did not seem to crash. Recovery window with
all opened workbooks appeared when I opened Excel after your 1st response.

Signature

REM

> Do you have any code that saves the file silently upon closing?
>
[quoted text clipped - 12 lines]
> >The date changes in Windows Explorer
> > REM

Reply to this Message

REM - 15 Nov 2006 23:18 GMT

Gord

Excel DOES NOT ask if I want to save the changes when I open and close.
In Word the dialog box opens and asks yes/no/cancel

REM

Signature

REM

> It remains with the changed modified date even after closing with no changes?
>
[quoted text clipped - 12 lines]
> >Regards,
> >REM

Reply to this Message