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. Type PivotTableNetworkResiliency, and then press ENTER.ĭouble-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. This functionality was introduced in Microsoft Excel 2000 as a single registry key.įor more information about how to resolve this issue in Excel 2000, click the following article number to view the article in the Microsoft Knowledge Base:Ģ30164 You may receive an error message when you try to save files in Excel 2000 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. Resiliency for VBA objects and OLE objects Starting with Excel 2002, the network resiliency feature is subdivided into two categories, to permit better control and to additionally make sure that you can recover from the loss of network connectivity. Resiliency for Microsoft PivotTable cachesīy 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 have no user interface. They are controlled by registry entries, and are configurable only by manually editing the registry or by policy.Type excel.exe /safe in Run box to open the Excel in safe mode. Opening Excel in safe mode, click "File" > "Options" > "Add-ins".
Try to end antivirus as well as the running applications to see if the issue is removed.
Go to the Control Panel > click on "Devices and Printers" > set "Microsoft XPS Document Writer". Go to the "Control panel" > choose "Programs and Features" > click "Change". Open Excel and click on "Developer" > "Visual Basic". Microsoft Excel Has Stopped Working When Saving Go to "File" > "Account".Under Product Information, choose "Update Options". "Last night, when I finished working on a complex workbook and tried to save it, Windows reported that 'Microsoft Excel has stopped working' and didn't allow any operation on the document.
0 kommentar(er)
