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:
Keywords
warning, overlapping, Crosstab1, Crosstab2, rows, refresh, workbook, ID-103030, Komponente Crosstab , KBA , BI-RA-AO-XLA , Excel Addin , Problem