PerformancePoint Add-in for Excel does not preserve the cell style that you applied to a cell

Article translations Article translations
Article ID: 940657 - View products that this article applies to.
Expand all | Collapse all

SYMPTOMS

Consider the following scenario. You open an assignment in Microsoft PerformancePoint Add-in for Excel. In a matrix, you change the cell style of a cell. Additionally, a style is applied to the matrix. Then, you click the Refresh button to update the worksheet that contains the cell.

In this scenario, PerformancePoint Add-in for Excel does not preserve the cell style that you applied to the cell.

RESOLUTION

To resolve this issue, follow these steps:
  1. Click Start, point to All Programs, point to Microsoft Office, and then click Microsoft Office Excel 2007.
  2. In Excel 2007, click the PerformancePoint tab.
  3. In the Connection group, click Connect to connect to the server that is running Microsoft Office PerformancePoint Server 2007.
  4. In the PerformancePoint pane, open the assignment in which you want to apply the cell style to the cell.
  5. Click the cell in the matrix for which you want to apply the cell style.
  6. In the Authoring group, click Matrix Styles.
  7. In the Matrix Styles dialog box, select (None) in the Available Styles list, and then click OK.
After you set the style of the matrix to (None), PerformancePoint Add-in for Excel applies the default cell style to the cell.

Additionally, when you click the Refresh button to update the worksheet that contains the cell, PerformancePoint Add-in for Excel preserves the cell style that you applied to the cell in the matrix.

Properties

Article ID: 940657 - Last Review: September 18, 2007 - Revision: 1.1
APPLIES TO
  • Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
  • Microsoft Office PerformancePoint Server 2007, 64 Bit Edition
Keywords: 
kbtshoot kbprb kbexpertiseadvanced KB940657

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