Microsoft KB Archive/940657

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

Article ID: 940657

Article Last Modified on 9/18/2007

-

APPLIES TO


 * Microsoft Office PerformancePoint Server 2007, 32 Bit Edition
 * Microsoft Office PerformancePoint Server 2007, 64 Bit Edition

-



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.

Keywords: kbtshoot kbprb kbexpertiseadvanced KB940657

-

[mailto:TECHNET@MICROSOFT.COM Send feedback to Microsoft]

© Microsoft Corporation. All rights reserved.