If the problem is fixed, you're finished with this section. Select OK.Ĭheck whether the problem is fixed. Add the following registry value:ĭouble-click ForceShellExecute, and then set the Value data to 1. On the Edit menu, point to New, and then select DWORD Value. Make sure the Internet subkey is selected. HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\9.0\Common\Internetįor a 64-bit version of Office on a 64-bit version of Windows: HKEY_LOCAL_MACHINE\SOFTWARE\Wow6432Node\Microsoft\Office\9.0\Common\Internetįor a 32-bit version of Office on a 32-bit version of Windows: In Registry Editor, browse to one of the following subkeys (create the keys if they do not exist):įor a 32-bit version of Office on a 64-bit version of Windows: Type regedit in the Open box, and then select OK. To work around this issue, either add the ForceShellExecute subkey, if it is not present, and set the Value data, or if it is present, set the Value data of the ForceShellExecute subkey.
#What if excel cannot locate server for external data 2011 how to
For more information about how to back up and restore the registry, select the following article number to view the article in the Microsoft Knowledge Base:ģ22756 How to back up and restore the registry in Windows Add the Internet Subkey to the registry and set the Value data
Then, you can restore the registry if a problem occurs. For added protection, back up the registry before you modify it. Therefore, make sure that you follow these steps carefully. However, serious problems might occur if you modify the registry incorrectly. This section, method, or task contains steps that tell you how to modify the registry.
0 kommentar(er)
