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

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

Analysis for Microsoft Office

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

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

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.

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:

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