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

Article ID: 913149
Notice
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
Expand all | Collapse all

SYMPTOMS

You try to open the same Microsoft Excel worksheet on different computers. However, you cannot open the Excel worksheet on some computers.

CAUSE

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.

RESOLUTION

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:
    \HKEY_CURRENT_USER\Software\Microsoft\Office\11.0\Excel\Options
  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.

MORE INFORMATION

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.

Properties

Article ID: 913149 - Last Review: July 28, 2011 - Revision: 2.0
Keywords: 
kbmbsmigrate kbprb KB913149

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com