Component Crosstab1 overlap with excel cell content. 98 rows have been cut.

[vissufeb13]

Dear Team,

I have an issue in Analysis office. One of the user is getting the below error.

Component Crosstab1 overlap with excel cell content. 98 rows have been cut.

Can any one help us how we can overcome this issue.

Thanks

Viswa

[VijayetaSharma · Accepted solution]

Hello vissufeb13,

This warning message appears in two scenarios-

1. User have accidental entered something in row 98 and that is stooping workbook to refresh and populate numbers on that specific sheet.
   Fix - select the entire sheet and then click on "delete" button on the keyboard. This will delete the content of the sheet and not the cross tab itself. > Then click on refresh all on top. This should resolve the issue.
2. User may have inserted more than one cross table in same sheet - Go to display > components and expand each node on top. If you see multiple nodes on top > expand each of them and check if more than one node is mapped to same sheet. If so remove one of them and map it to new sheet. Refresh all.

This is quite common issue with user defined workbooks.

If you find shared info helpful, dont forget to accept (accept button at the bottom) and vote (votting arrows on the left side)

Thanks,
Vijayeta

[vissufeb13]

Thank you very much for your reply Vijayeta.

First option has worked, and trying the second option as well if any multiple node has included or not.

Thanks

Viswa