Microsoft KB Archive/324491

= You receive a &quot;The file may have been changed&quot; error message when you save a workbook to a network server in Excel 2002 or in Excel 2003 =

Article ID: 324491

Article Last Modified on 2/1/2007

-

APPLIES TO


 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q324491





Important This article contains information about modifying the registry. Before you modify the registry, make sure to back it up and make sure that you understand how to restore the registry if a problem occurs. For information about how to back up, restore, and edit the registry, click the following article number to view the article in the Microsoft Knowledge Base:

256986 Description of the Microsoft Windows Registry



SYMPTOMS
When you try to save a Microsoft Excel workbook to a network server, you may receive the following message if the server is running an intermediate service, such as Services for Macintosh, or there is latency in the network connection during the book open:

The file ( .xls) may have been changed by another user since you last saved it. In that case, what do you want to do?
 * Save a copy
 * Overwrite changes

Save a copy is the default choice.



CAUSE
This message is a new feature in Microsoft Excel 2002 that protects you from overwriting someone else's changes if you lose network connectivity.

If you open a file from a network drive and then your computer loses network connectivity, a second person can open the same file, make changes, save, and then close the file without your knowledge.

If you then try to save the file, Excel compares the time stamp of the file in memory with the time stamp of the file on the network drive. If the time stamp does not match, Excel prompts you with the message described earlier.

There are two conditions when a user may receive this prompt incorrectly:
 * When you save the file on a network server that is running an intermediate service, the computer may write additional information to the file after Excel obtains the time stamp. For example, computers running Services for Macintosh will write additional Macintosh-related information to each file. This can occur after the time stamp is obtained by Excel.
 * For files opened with write access, Excel will write owner information to the file and induce a change in the last modified time stamp. Excel will collect the time stamp information after this write operation is completed successfully, and the rest of the workbook is read in. However, if there is latency in the network, it is possible the file will not be completely updated from the local file cache when Excel asks for the time stamp. Therefore, the server may return the time value as set before the last edit, and will not match what Excel expects when it checks the time on save. This can occur more frequently if the file is located on Network Appliance (NetAPP) storage device or across a Wide Area Network (WAN).

When you try save the file, Excel detects the difference in time stamps between open and save, and prompts you accordingly.



RESOLUTION
Note Do not deploy the following registry key unless you are sure of the root cause of the warning message. If you deploy this registry key without knowing what is causing the warning message to appear, you could potentially mask a larger network or server issue.

Warning If you use Registry Editor incorrectly, you may cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that you can solve problems that result from using Registry Editor incorrectly. Use Registry Editor at your own risk.

Excel 2003
To resolve this issue in Excel 2003, follow these steps:  Click Start, click Run, type regedit, and then press ENTER. Locate and then click the following key:

 

 On the Edit menu, point to New, and then click DWORD Value. Type QFE_Saskatchewan for the name, and then press ENTER. Right-click the  entry, and then click Modify.</li> In the Value box, type 2. When you type this value, Excel will always flush the file cache before the program obtains the time stamp. (This should resolve the problem most of the time.) Or, type 1 to have Excel disable the time stamp check and suppress the dialog in every case.

Note We do not recommend disabling the time stamp check.</li> Click OK to save the setting.</li></ol>

Excel 2002
This problem was first fixed in a hotfix that is now contained in a Service Pack. If you have installed the latest Office XP Service Pack, you do not have to install the hotfix.

Service Pack Information
This problem is corrected in Office XP Service Pack 3.

To resolve this problem, obtain the latest service pack for Microsoft Office XP. For additional information, click the following article number to view the article in the Microsoft Knowledge Base:

307841 How to obtain the latest Office XP service pack

To enable the fix
To enable this design change, follow these steps: <ol> Click Start, click Run, type regedit in the Open box, and then press ENTER.</li> Locate and then click the following key:

 

</li> On the Edit menu, point to New, and then click DWORD Value.</li> Type QFE_Saskatchewan for the name, and then press ENTER.</li> Right-click the   entry, and then click Modify.</li> In the Value box, type 2 to have Excel always flush the file cache before obtaining the time stamp. This should resolve the problem most of the time. Or, type 1 to have Excel disable the time stamp check and suppress the dialog in every case.

Note We do not recommend disabling the time stamp check.</li> Click OK to save the setting.</li> Re-start Excel to have the setting take effect for that user.</li></ol>

How to obtain the hotfix
This issue is fixed in the Excel 2002 Post-Service Pack 2 hotfix package that is dated June 7, 2003.

For more information, click the following article number to view the article in the Microsoft Knowledge Base:

822347 Description of Excel 2002 post-Service Pack 2 hotfix package: June 7, 2003

<div class="workaround_section">

WORKAROUND
To work around this problem, use one of the following methods:
 * Share your Excel workbooks by clicking Share workbook on the Tools menu. You can restrict access to the file by using the share permissions. Shared workbooks keep track of multi-user edits and do not require the time stamp check.
 * Save your files to a Microsoft Windows 2000 or Microsoft Windows Server 2003 on a Local Area Network (LAN), and disable services that can modify the file unexpectedly, such as the Services for Macintosh.
 * If you are sure that you are the only person who has access to the file or you are the only person who is using the file, just click Overwrite changes in the dialog box.

<div class="status_section">

STATUS
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the &quot;Applies to&quot; section. This problem was first corrected in Office XP Service Pack 3.

Note To enable the hotfix, you must add the registry key that is documented in the &quot;Resolution&quot; section after Office XP Service Pack 3 is installed.

Additional query words: sfm XL2002 xl2003

Keywords: kbqfe kbhotfixserver kbbug kberrmsg kbnofix KB324491

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.