The issue occurs when an Excel file containing macros or VBA code is saved over the network. The error message that is received is "Document not saved". Information about this error message is provided at the following URL:
URL: http://support.microsoft.com/kb/291204
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.
- Click Start, 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 2002HKEY_CURRENT_USER
Software
Microsoft
Office
10.0
ExcelMicrosoft Office Excel 2003
HKEY_CURRENT_USER
Software
Microsoft
Office
11.0
ExcelMicrosoft Office Excel 2007
HKEY_CURRENT_USER
Software
Microsoft
Office
12.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.
- 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.
No comments:
Post a Comment