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