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:
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