Troubleshoot the PerformancePoint Add-in for Excel
The following table shows some common troubleshooting issues and resolutions along with commands to use with the PerformancePoint Add-in for Excel diagnostics tool. Use the procedure and the table below to troubleshoot and resolve issues with the PerformancePoint Add-in for Excel.
PivotTable Services 8.0 is the OLE DB provider for Microsoft SQL Server 2000 Analysis Services and is used to connect with an Analysis Services 2000 server. PivotTable Services does not work with SQL Server 2005 Analysis Services. Therefore, client applications that connect to Analysis Services in both SQL Server 2000 and SQL Sever 2005 will need to install both PivotTable Services 8.0 and Analysis Services 9.0 OLE DB Provider in a side-by-side configuration.
If connection to a server that runs SQL Server 2000 Analysis Services is required, you will need to install Pivot Table Services 8.0 first and then install Pivot Table Services 9.0 after. If this is done out of order, errors may occur that refer to an incorrect version of Pivot Table Services 8.0 SP2.
Use the PerformancePoint Add-in for Excel diagnostics tool
Click Start, point to Programs, point to Microsoft Office PerformancePoint Server 2007, and then click Planning Configuration Settings.
In the Configure PerformancePoint Add-in for Excel dialog box, click Diagnostics.
On the Diagnostics tab, click Run diagnostics. The diagnostics text field is populated with XML attributes for the PerformancePoint Add-in for Excel.
Review this information and use the following table to determine the cause of any problems.
Diagnostic troubleshooting table
| Issue | Element | Required Value | Solution |
|---|---|---|---|
Unexpected characters appear throughout the interface. Dates and times are formatted differently than in the rest of the operating system. |
<UICulture> |
The same language as the operating system language, unless a Multilingual User Interface Pack is installed |
Install a Multilingual User Interface Pack for Microsoft Office from Office Update (https://go.microsoft.com/fwlink/?LinkId=76114). |
PerformancePoint Add-in for Excel does not function, or functions with many errors. |
<Excel> <DotNetProgrammability> |
The version numbers that are shown in these two elements must match. |
Reinstall or repair Office Excel, and select the .NET Programmability option. |
My report will not populate with data from PerformancePoint Planning Server. |
<Cellset> |
2.7 or later |
Reinstall SQL Server 2005 client components. |
When I open Excel, the PerformancePoint Planning menu does not appear. |
<AddinLoadBehavior> |
3 |
Make sure that the Microsoft .NET Framework version 2.0 or later is installed. Uninstall any other PerformancePoint Add-in for Excel instances, and then reinstall PerformancePoint Add-in for Excel. |
Use best practices
If Office Excel 2007 is installed on your computer and you have difficulty installing the PerformancePoint Add-in for Excel, check the macro security settings for Excel. If the security settings are set to High or Very High, select Trust all installed add-ins and templates.
Do not open the same offline assignment from two concurrent instances of PerformancePoint Add-in for Excel. If the same offline assignment is opened in this manner, synchronization errors and data loss can occur.