Final answer:
Yes, one can use Power Query (Get & Transform) in Excel to create a dynamic connection to an existing table and refresh the connection when the data changes.
Step-by-step explanation:
You can use Power Query to import to a single data source, such as an Excel workbook, or to multiple databases, feeds, or services scattered across the cloud. Data sources include data from the Web, files, databases, Azure, or even Excel tables in the current workbook. Yes, one can use the Get & Transform (Power Query) feature of Excel to create a dynamic connection to an existing Excel table and refresh the connection when the data in the table changes. Power Query allows users to import, transform, and combine data from various sources, including Excel tables.
By creating a connection to an Excel table, any changes made to the table will automatically be reflected in the imported data in Power Query. Users can also set up automatic refresh options to update the data periodically. For example, if you have an Excel table with sales data, you can use Power Query to import that data and create a dynamic connection. If new sales data is added to the table or existing data is modified, the Power Query connection can be refreshed to automatically update the imported data.