|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
November 15th, 2006, 09:15 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
Workbook Date
why is the date on workbooks changing when I open it.
Workbook dates used to change only when changes were made. -- REM 
|
|
#2
November 15th, 2006, 10:07 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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 On Wed, 15 Nov 2006 13:15:02 -0800, REM wrote: why is the date on workbooks changing when I open it. Workbook dates used to change only when changes were made.
|
|
#3
November 15th, 2006, 10:33 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
Gord
Thanks. It is the Modified Date. It is changing even when I am not saving the file. Regards, REM -- REM "Gord Dibben" wrote: 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 On Wed, 15 Nov 2006 13:15:02 -0800, REM wrote: why is the date on workbooks changing when I open it. Workbook dates used to change only when changes were made.
|
|
#4
November 15th, 2006, 10:53 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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 FileOpen dialog? Do not open the file before checking the modified date. Gord Dibben MS Excel MVP On Wed, 15 Nov 2006 14:33:01 -0800, REM wrote: Gord Thanks. It is the Modified Date. It is changing even when I am not saving the file. Regards, REM
|
|
#5
November 15th, 2006, 11:13 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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 -- REM "Gord Dibben" wrote: 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 FileOpen dialog? Do not open the file before checking the modified date. Gord Dibben MS Excel MVP On Wed, 15 Nov 2006 14:33:01 -0800, REM wrote: Gord Thanks. It is the Modified Date. It is changing even when I am not saving the file. Regards, REM
|
|
#6
November 15th, 2006, 11:18 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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 -- REM "Gord Dibben" wrote: 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 FileOpen dialog? Do not open the file before checking the modified date. Gord Dibben MS Excel MVP On Wed, 15 Nov 2006 14:33:01 -0800, REM wrote: Gord Thanks. It is the Modified Date. It is changing even when I am not saving the file. Regards, REM
|
|
#7
November 15th, 2006, 11:50 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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 On Wed, 15 Nov 2006 15:13:01 -0800, REM wrote: 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
|
|
#8
November 16th, 2006, 03:02 PM
posted to microsoft.public.excel.setup
|
|||
|
|||
|
Workbook Date
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. -- REM "Gord Dibben" wrote: 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 On Wed, 15 Nov 2006 15:13:01 -0800, REM wrote: 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
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
