When writing to an Excel Workbook on One Drive or SharePoint and overwriting a table, the "link" to the workbook stays with the automated backup file and the file is assigned a new link. Access to this workbook is controlled through another interface by the link.
Is there any way to overwrite a table and not break the One Drive or SharePoint link?
