In earlier versions (through xl2k, IIRC (xl97 for sure)), you could right click
on the filename in the File|open dialog and choose "open read-only".

In newer (all???) versions, you can select the file and then click on the
dropdown arrow on the Open button in the File|Open dialog and choose "open
read-only".

"Jerry W. Lewis" wrote:

The only way I know of to avoid this is to open the file Read Only.
Since there is not a Read Only option in the file open dialog, this
means that you either must use a VBA command to open, or else set the
read only property of the file (right click on file from Windows
Explorer) before you open it.

I don't know how long Myrna can remember ;-) but I recall that Excel has
worked this way at least since Excel 5. I have found it problematic,
because the date-time stamp gets permanently changed, despite no changes
to the file, if there is any kind of abnormal termination of Excel
(power failure, crash, etc.) before the file is closed.

Jerry

GROSNER wrote:

In Excel 2002 SP3 on Win XP, the workbook's file modification date changes to
the current date and time as soon as the Excel workbook is opened, even if
there are no changes applied to the file. If you close the workbook without
changing any of its contents, the file modification date reverts back to the
original value. Is there any way for the file modification date to remain
unchanged until afte the Excel workbook has been modified? Does this behavior
occur in newer versions of Excel?

--

Dave Peterson