Excel DataLink Updating error when adding rows in Excel Link

Hello all, I have tried this both ways by defining a range name in excel and linking to it and also using link to range in the Modify excel Link dialogue in Autocad. I am using AutoCad 2020, I have also tried this in 2017, 2018. It has never worked correctly for me, I hope there is some easy way of making this work. If you look at the images below you see the row doesn't update correctly, the extra row is on line 24 and DatalinkUpdate puts the extra row at the bottom and does not shift other rows down accordingly. I am using Version 16 excel also if that makes any difference. Thank you.

Attachment 107948Attachment 107949