Microsoft Knowledge Base Article
This article contents is Microsoft Copyrighted material.
©2005-©2007 Microsoft Corporation. All rights reserved.
Terms
of Use |
Trademarks
Article ID: 948355 - Last Review: January 11, 2012 - Revision: 2.0
The modified date of the original.xls file is not reset to the original modified time stamp when you save an .xls file in Excel 2007 & Excel 2010
In Microsoft Office Excel 2007/2010, you open an .xls file that is located on a network share and then save it with a different name. When you do this, the modified date of the original .xls file is not reset to the original modified date and time as expected.Â
Note This issue does not occur when the .xls file is located on a local
disk or when the file has an .xlsx, an .xlsm, or an .xlsb file format.
This issue occurs because Excel 2007/2010 writes the name of the current user to the header of the file when you open an Excel workbook. This process is required so that other users receive the "file in use" notification. The operating system then updates the last modified date.Â
To work around this issue, follow these steps:
- Right-click
the file, and then click Copy.
- In
the Windows Explorer window, right-click in a blank space, and then click
Paste.
- Right-click
the file, click Rename, and then type the new name for the
file.
- Double-click
the file to edit it in Excel.
For more information, click the following article number
to view the article in the Microsoft Knowledge Base:
826741Â
(http://kbalertz.com/Feedback.aspx?kbNumber=826741/
)
Excel changes Modified date and time when you open the workbook
Note This is a "FAST PUBLISH" article created directly from within the Microsoft support organization. The information contained herein is provided as-is in response to emerging issues. As a result of the speed in making it available, the materials may include typographical errors and may be revised at any time without notice. See
Terms of Use
(http://go.microsoft.com/fwlink/?LinkId=151500)
for other considerations.
APPLIES TO
- Microsoft Office Excel 2007
- Microsoft Excel 2010
| kbharmony kbtshoot kbexpertisebeginner KB948355 |
Community Feedback System
Very often, it takes hours to solve a problem. Very often, you've looked high
and low, and have tried a lot of solutions. When you finally found it, chances
are, it was because someone else helped you. Here's your chance to give back.
Use our community feedback tool to let others know what worked for you and what
didn't.
Please also understand that the community feedback system is not warranted to be
correct, it's simply a system that we've built to let people try and help each
other. If something in a feedback response doesn't make sense to you, or you're
not comfortable making changes that the feedback talks about (like registry
edits), please consult a professional.
Thank you for using kbAlertz.com Feedback System.
-- Scott Cate