I have set up a chain to pull data from our data warehouse and then import automatically to a table linked to a query. This then is linked to an Excel file. I need to refresh the connection to get the new data. Once the new data is there I need to click the Publish button manually.
Can we automate refreshing connections in excel and publishing data to powerpoint?