cancel
Showing results for 
Search instead for 
Did you mean: 

Refresh data in an Excel spreadsheet without opening it

Hi

 

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