PSS ID Number: 820748
Article Last Modified on 8/22/2003
The information in this article applies to:
- Microsoft Office Excel 2003
Template: zGeneric Problem Article
For a Microsoft Excel 2002 version of this article, see 291204.
For a Microsoft Excel 2000 version of this article, see 230164.
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
In Excel 2003 when you try to save your workbook, you receive the following error message (where Network path is the network location where you are trying to save your file):
When you try to save your workbook to another location, you receive the following error message:
CAUSE
This issue 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
- Microsoft Visual Basic for Applications (VBA) modules.
- Embedded objects (such as clip art).
- Network Resiliency and Pivot Table Network Resiliency have both been turned off (by setting their registry values to 0).
Note If Network Resiliency is turned on and Pivot Table Network Resiliency is turned off, you see the first error message that is noted in the "Symptoms" section, and then when you try to save the workbook to a different location, you do not see the second error message.
WORKAROUND
To prevent this issue from occurring, turn on both Network Resiliency and Pivot Table Network Resiliency. 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.
- Click Start, and then click Run.
- In the Run box, type regedit, and then click OK.
- In Registry Editor, locate the following subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\NetworkResiliency - Click NetworkResiliency, on the Edit menu, click Modify.
- In the Edit DWORD Value dialog box, in the Value data box, type 1, and then click OK.
- In Registry Editor, located the following subkey:
HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options\NetworkResiliency\PivotTableNetworkResiliency - Click PivotTableNetworkResiliency, on the Edit menu, click Modify.
- In the Edit DWORD Value dialog box, in the Value data box, type 1, and then click OK.
These changes take effect the next time that you start Excel. For both registry values, setting the value to 0 turns the setting off and 1 turns the setting on.
MORE INFORMATION
In Excel 2003, the network resiliency feature is divided into two categories, to permit better control and to additionally make sure that you can recover from the loss of network connectivity. The two divisions are:
- Resiliency for VBA objects and OLE objects.
-and-
- Resiliency for Microsoft PivotTable caches.
By default, the resiliency for VBA and OLE is set to On and the resiliency for PivotTable caches is set to Off. The PivotTable cache is off because you can save a pivot table even when the cache is unavailable. A PivotTable does not produce the threat of causing a file not to save when network connectivity is lost.
The network resiliency settings do not have a user interface, and are controlled either by manually editing registry entries or by using policy.
Additional query words: XL2003 prb
Keywords: kberrmsg kbprb KB820748
Technology: kbExcel2003 kbExcel2003Search kbExcelSearch kbExcelWinSearch
