SAP Knowledge Base Article - Public

2789774 - 2.x Analysis Office: hidden lines and columns are not preserved when refreshing a data source

Symptom

A workbook contains crosstabs which contain hidden lines or columns.

When refreshing one data source, all hidden lines and columns in worksheets are displayed.

Environment

SAP Analysis for Microsoft Office

Cause

This is not a bug but the expected behavior.

Resolution

  1. Add following line on file Ao_user_roaming.config (located on %APPDATA%\SAP\Cof) inside the section <configuration></configuration>:
    <PreserveHiddenLinesAndColumnsWhenRefreshingGrid value="true" />

  2. Add following line on file Ao_app.config (located on %PROGRAMDATA%\SAP\Cof) inside the section <configSections></configSections>:
    <section name="PreserveHiddenLinesAndColumnsWhenRefreshingGrid" type="Boolean" configurationLevel="UserRoaming" />

Refer to KBA 2083067 for more details on how to maintain the settings of Analysis Office.

See Also

  • SAP Note 1974481 - Analysis Office: hidden lines and columns are not preserved when refreshing a data source

Keywords

hidden, lines, columns, refresh, unhide , KBA , BI-RA-AO-XLA , Excel Addin , How To

Product

SAP Analysis for Microsoft Office all versions