To prevent this problem from occurring, you can add the NetworkResiliency and PivotTableNetworkResiliency subkeys to the registry. To do this, follow these steps.Warning
Serious problems might occur if you modify the registry incorrectly by using Registry Editor or by using another method. These problems might require that you reinstall the operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
, and then click Run
In the Open
box, type regedit
, and then click OK
In the left pane, expand the following items in the order that they appear, as appropriate for the version of Excel that you are running.Microsoft Excel 2002
HKEY_CURRENT_USERMicrosoft Office Excel 2003
HKEY_CURRENT_USERMicrosoft Office Excel 2007
In the left pane, click the Options
On the Edit
menu, point to New
, and then click DWORD Value
, and then press ENTER.
Double-click the NetworkResiliency
In the Value data box, type 1, and then click OK.
On the Edit menu, point to New, and then click DWORD Value.
Type PivotTableNetworkResiliency, and then press ENTER.
Double-click the PivotTableNetworkResiliency icon.
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 keys, setting the key to 0 turns the setting off and 1 turns the setting on. The only difference between the two registry keys is that the default value when the registry keys are not present are On for VBA and OLE, and Off for PivotTable Cache.