XL2000: Error Saving File After Network Connection Has Been Lost

ID: Q230164

The information in this article applies to:

Microsoft Excel 2000

IMPORTANT: This article contains information about editing the registry. Before you edit the registry, make sure you understand how to restore it if a problem occurs. For information about how to do this, view the "Restoring the Registry" Help topic in Regedit.exe or the "Restoring a Registry Key" Help topic in Regedt32.exe.

SYMPTOMS

When you attempt to save your workbook, you receive the following error message:


   Microsoft Excel cannot access the file '<Network path>'. There are 
   several possible reasons:

    - The file name or path does not exist.

    - The file you're trying to open is being used by another program. 
      Close the document in the other program, and try again.

    - The name of the workbook that you're trying to save is the same as 
      the name of another document that is read-only. Try saving the 
      workbook with a different name.

where <Network path> is the network location where you are trying to save your file.

When you attempt to save your file to another location, you receive the following error message:


   Document not saved

CAUSE

This problem may occur if the following conditions are true:

You are saving your file to a network drive.

-and-
The connection to the network drive has been lost.

-and-
Your workbook contains any of the following items:
- PivotTables
- Visual Basic for Applications modules.
- Embedded objects (such as clipart).

WORKAROUND

To prevent this problem from occurring, you can add the NetworkResiliency subkey to the registry. To do this, follow these steps:

WARNING: Using Registry Editor incorrectly can cause serious problems that may require you to reinstall your operating system. Microsoft cannot guarantee that problems resulting from the incorrect use of Registry Editor can be solved. Use Registry Editor at your own risk.

For information about how to edit the registry, view the "Changing Keys and Values" Help topic in Registry Editor (Regedit.exe) or the "Add and Delete Information in the Registry" and "Edit Registry Data" Help topics in Regedt32.exe. Note that you should back up the registry before you edit it. If you are running Windows NT, you should also update your Emergency Repair Disk (ERD).

Click Start, and then click Run. In the Open box, type regedit. Click OK.

In the left pane, click the plus signs (+) to the left of the following items (in order):

HKEY_CURRENT_USER
Software
Microsoft
Office
9.0
Excel

In the left pane, click the Options folder.

On the Edit menu, point to New, and then click DWORD Value.

Type NetworkResiliency, and then press ENTER.

Double-click the NetworkResiliency icon.

Type 1 in the Value data box, and then click OK.

This change will take effect the next time that you start Excel.

You will still receive the first error message listed in the "Symptoms" section when you attempt to save a file after you lose network connectivity. However, you will be able to save your file to another location.

NOTE: Your files will open and save more slowly after you add the NetworkResiliency subkey to the registry.

Additional query words: XL2000

Keywords :
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbbug