SAP Knowledge Base Article - Public

2554438 - How to change cell styles in Analysis Office

Symptom

You would like to modify cell styles in Analysis Office

Environment

SAP Analysis for Microsoft Office

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 Support Content 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

Product

SAP BusinessObjects Analysis for Microsoft Office 2.5