Updating Calc DDE links on added rows

When updating a linked Calc spreadsheet, when rows are added, updating the link in Writer does not add the rows.

The entire DDE link needs to deleted and recreated with the new added rows, thus needing to recreate the styles.

Chaging range number sin links, If no new rows are added updates the rows fine. No problem there.

But the issues are around new rows being added and updating the links accordingly.

Is there any way around this? Would it be best doe with a macro?

Thank you.