Regarding the issue at hand, there is no need to create a dynamic connection as the existing connection is functioning correctly. The error message indicates that the Excel table name has changed. In Excel, each table has a unique GUID name, and when you replace the file, the display name of the table remains the same while the underlying GUID name changes.
To address this error and update the data in Excel without replacing the Excel file, you can leverage Power Automate. Power Automate provides functionality to automate workflows and integrates well with Excel. By utilizing Power Automate, you can modify the data within the Excel table while keeping the existing table name intact. This eliminates the need to change the table name every time you update the data.
