2554438 - How to change cell styles in Analysis Office

Symptom

You would like to modify cell styles in Analysis Office

Environment

SAP Business Objects Analysis, edition for Microsoft Office 2.x

Reproducing the Issue

A style set is a collection of Microsoft Excel cell styles that is applied by Analysis to format the cells of a crosstab. Whenever you insert a new crosstab in a workbook, the styles in the current default style set are used to format the crosstab cells.

With Analysis, the following style sets and their cell styles are installed:

SAP Blue (default)
SAP Black&White
SAP Tradeshow Plus
SAP Blue Crystal

By modifying the cell styles of these style sets, you can create your own style sets and share them with other users.

Resolution

You can refer to the steps in wiki page and change cell styles:

https://wiki.scn.sap.com/wiki/x/P4iQGg

Keywords

AO, Analysis Office, Styles, StyleSet, cell styles , KBA , BI-RA-AO-XLA , Excel Addin , BI-RA-AO-PPA , Please use component BI-RA-AO-XLA , How To

Product

SAP BusinessObjects Analysis for Microsoft Office 2.5