You cannot open an Excel worksheet in Enterprise Reporting on some computers

Important This article contains information about how to modify the registry. Make sure to back up the registry before you modify it. Make sure that you know how to restore the registry if a problem occurs. For more information about how to back up, restore, and modify the registry, click the following article number to view the article in the Microsoft Knowledge Base:
256986 Description of the Microsoft Windows registry
This article has been archived. It is offered "as is" and will no longer be updated.
You try to open the same Microsoft Excel worksheet on different computers. However, you cannot open the Excel worksheet on some computers.
This issue occurs when the path for the EnterpriseReportingXP.xla file is not the same on all computers.

In Enterprise Reporting, the default installation path has changed from C:\Program Files\Great Plains\Enterprise Reporting to C:\Program Files\Microsoft Business Solutions\Enterprise Reporting. Therefore, many computers that use an upgraded Excel Add-in installation use the old path. New installations of the Excel Add-in use the new path.
To resolve this issue, follow these steps:
  1. Select the path that you want to use for the Excel Add-in installation.
  2. Make sure that all Excel Add-in installations use the same path.
If you still experience the problem on some computers, you must change the path in the registry on those computers.

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 your operating system. Microsoft cannot guarantee that these problems can be solved. Modify the registry at your own risk.
  1. Click Start, click Run, type Regedit, and then click OK.
  2. Locate the following subkey:
  3. Locate the OPEN entry.
  4. Right-click OPEN, and then click Modify.
  5. Make sure that the path in the Value data field is the correct path for the Excel Add-in.
The registry setting is not automatically changed if you change the path for the Excel Add-in that is already installed. Therefore, you must manually change the registry setting after you have changed the installation path.

Article ID: 913149 - Last Review: 01/14/2015 03:30:32 - Revision: 2.0

  • kbnosurvey kbarchive kbmbsmigrate kbprb KB913149