Showing results for 
Search instead for 
Did you mean: 

Refresh data in an Excel spreadsheet without opening it



I've recently managed to use Flow to manipulate data from my database into Excel speadsheets.


I've then connected these spreadsheets to a master data table which also lives in Sharepoint. However, for this data to refresh I have manually open it and refresh the data connections every day. 


Can a connector be built to replicate this manual task, so that I could refresh the data contained within a spreadsheet based on a trigger action (i.e. an email being sent)


Many thanks

Status: New