Article ID: 324491 - View products that this article applies to.
This article was previously published under Q324491
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:
Save a copy is the default choice.
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:
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.
Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
Excel 2003To resolve this issue in Excel 2003, follow these steps:
Excel 2002This 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 InformationThis 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:
(http://support.microsoft.com/kb/307841/ )How to obtain the latest Office XP service pack
To enable the fixTo enable this design change, follow these steps:
How to obtain the hotfixThis 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:
(http://support.microsoft.com/kb/822347/ )Description of Excel 2002 post-Service Pack 2 hotfix package: June 7, 2003
To work around this problem, use one of the following methods:
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" 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 "Resolution" section after Office XP Service Pack 3 is installed.