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

Symptom

You have a workbook that contains Analysis Office (AO) crosstabs that you hide one or more lines or columns.

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

Environment

SAP Analysis for Microsoft Office

Product

SAP Analysis for Microsoft Office 2.6 ; SAP Analysis for Microsoft Office 2.7 ; SAP Analysis for Microsoft Office 2.8 ; SAP BusinessObjects Analysis 2.0, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.1, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.2, edition for Microsoft Office ; SAP BusinessObjects Analysis 2.4, edition for Microsoft Office

Keywords

Hiden lines columns refresh analysis for office , KBA , BI-RA-AO-XLA , Excel Addin , How To

About this page

This is a preview of a SAP Knowledge Base Article. Click more to access the full version on SAP for Me (Login required).

Search for additional results

Visit SAP Support Portal's SAP Notes and KBA Search.