SAP Knowledge Base Article - Public

2913844 - Warning "Component XYZ overlaps with Excel cell content. X rows have been cut"

Symptom

The warning "Component XYZ overlaps with Excel cell content. X rows have been cut" occurs in Analysis Office.

Environment

Analysis for Microsoft Office

Cause

The warning usually occurs when there is already a content in a cell where Analysis Office is trying to load data.

Resolution

Try one or more of the actions below:

1)Remove the content of the cell in Excel so Analysis Office can load the data.

2)If the cell with content is not known, try to move the data source to a new sheet in Excel to make sure there is no content in any cell.

3)If the issue occurs when inserting a data source in a new workbook, check if there is a default workbook either in Excel's option "At startup, open all files in" or in the Options of Analysis Office, that is causing the issue, as shown in the screenshots below:

Workbook startup.png

Default workbook.png

Keywords

warning, overlapping, Crosstab1, Crosstab2, rows, refresh, workbook, ID-103030, Komponente Crosstab , KBA , BI-RA-AO-XLA , Excel Addin , Problem

Product

SAP Analysis for Microsoft Office all versions