Add Row in an Excel file from SharePoint

(1) Share

Report

Posted on by perrydan57

Hello,

When I am trying to add a row into an Excel table, I am receiving error 409

"message": "This won't work because it would move cells in a table on your worksheet.\r\nclientRequestId: 29998091-562d-4c3f-8e73-26fb0ad42d0a\r\nserviceRequestId: 61b2a6ae-5aff-40cc-b694-1e3162afddf2;4e9fbc44-a36e-4cb5-95ab-6e94b12037cc;ba293816-d7a9-455d-a554-19bd37238c5a;c33ef998-b8e6-4902-9ebf-7f8e3ecabac3".
 
That is my current flow:
Has anybody an idea for solving the issue

Categories:

Translation quality feedback

I have the same question (0)

All responses (2)

Answers (1)

Verified answer

trice602 15,404 Super User 2025 Season 2 on at

Like (0)

Report

Hi,

On the surface, the only thing I can think of is there are either merged cells somewhere on the workbook and may be interfering with the add a row into a table OR there is data below this table, even whitespace or a cell with a space in it and when you are trying to add a row to the table, it will not move that whitespace cell data down another row (or overwrite it). The latter is most likely the root cause but double check both.

------------------------------------------------

⭐ If this was helpful, please like and mark as a verified answer to help others find this too!

Always glad to help! 💯💯💯💯💯

Tom

Follow me on LinkedIn - Thomas Rice, PMP | LinkedIn

Was this reply helpful? Yes No
perrydan57 54 on at

Like (0)

Report

Thanks Tom,

unfortunately, that is not solving the issue.

I have created a new Excel in Teams, looking that I have no merged cell and no value.

I have only header line into it:

Any other idea?

Was this reply helpful? Yes No