Help and Support

You may receive an error message when you try to save files in Excel 2000

View products that this article applies to.
Article ID:230164
Last Review:February 2, 2005
Revision:4.0
This article was previously published under Q230164
For a Microsoft Excel 2002 and Microsoft Office Excel 2003 version of this article, see 291204 (http://support.microsoft.com/kb/291204/).


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 (http://support.microsoft.com/kb/256986/) Description of the Microsoft Windows Registry

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

Back to the top

CAUSE

This problem may occur if all the following conditions are true:
•You are saving your file to a network drive.
•The connection to the network drive has been lost.
•Your workbook contains any of the following items:
•PivotTables
•Visual Basic for Applications modules.
•Embedded objects (such as clip art).

Back to the top

WORKAROUND

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

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.
1.Click Start, and then click Run. In the Open box, type regedit. Click OK.
2.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
3.In the left pane, click the Options folder.
4.On the Edit menu, point to New, and then click DWORD Value.
5.Type NetworkResiliency, and then press ENTER.
6.Double-click the NetworkResiliency icon.
7.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.

Back to the top

APPLIES TO
•Microsoft Excel 2000 Standard Edition

Back to the top

Keywords: 
kberrmsg kbprb kbpending kbsavefile KB230164

Back to the top

Article Translations

 

Related Support Centers

Other Support Options

  • Need More Help?
    Contact a Support professional by Email, Online or Phone.
  • Customer Service
    For non-technical assistance with product purchases, subscriptions, online services, events, training courses, corporate sales, piracy issues, and more.
  • Newsgroups
    Pose a question to other users. Discussion groups and Forums about specific Microsoft products, technologies, and services.