I have a 'master' file with 500 stocks/tickers and around 100 data points for each ticker that I need to pull. I've been running into the issue where the file often gets stuck, crashes, or just takes a long time to update when I refresh.
Is power automate a valid option so that I could update the file automatically, at say 4am and 12pm every weekday? The issue is I have other files that pulls data from this 'master', so ideally I would want to try to not have to open this 'master' file, and it would automatically refresh twice a day at the specified times.
The other files that are pulling from the 'master' file are using index matches, so they would hopefully update automatically for the updated 'master' file if I open them and refresh them.
I am using the website version of PowerAutomate, where I go to make.powerautomate.com and can view the flow and run it.
