Forum Discussion
Shared File Connection Refresh Sharepoint
I have CSVs uploaded to a Sharepoint site 3x/day and I have established a connection to that Sharepoint folder from various Excel workbooks stored in the same Sharepoint site. These workbooks are sha...
BenDrury4 Have you tried creating an Office script that refreshes all connections and then creating a power Automate flow that runs that script against the files in question?
function main(workbook: ExcelScript.Workbook) {
// Refresh all data connections
workbook.refreshAllDataConnections();
}