Updating file that has Bloomberg and other add-in data daily

[PowerUser2]

I have a 'master' file of 500 tickers/stocks what has around 100 pieces of info for each ticker that has to be pulled and updated through the Bloomberg Add-in and then there's another add in that also pulls some relevant financial info. Because of how much data is being pulled, this often causes my excel to crash or takes forever to update.

I then have separate files that pull from this 'master' file using index matches. Ideally, I want the 'master' file to be updated once or twice a day at a set time, and then when I open the separate file I can refresh it and it will pull the updated info from the 'master' file.

I tried using Power Automate in the cloud, with workbook.refreshAllDataConnections, but I'm reading that unless the data source is Power Query or PowerBI, this wouldn't necessarily update the bloomberg or other add-in links.

Is the best option then creating a PowerScript shell to open, refresh all cells, save and then close the file? Thank you!

 

[PowerUser2]

I also wanted to add, that ideally the update could happen at say 4am and 7pm everyday kind of thing, where it would do this without me having to be in front of my computer executing a script.