Forum Discussion
Automate refresh all connections excel in Sharepoint folder
Hi everyone, how can I automate the data refresh connection everytime there's an update on my worksheet and file is being uploaded on a sharepoint folder. Thanks in advance 🙂
4 Replies
- I have a similar issue, the automate update only works for queries within the sheet at the moment. Looks like more options are in development
Hi rbalza
I guess there is no way to do this only with Excel functionality. Within Excel, for every query or connection you could set only an automatic refresh during file open or every X minutes:
To monitor a Sharepoint folder, you probably have to look into tools like Power Automate.
- Hi Martin_Weiss, thanks for taking the time on this. Yep that's what I did on desktop and upload it in Sharefolder. Unfortunately, that refresh thing is not working on cloud was it? Current work around is that I used power automate to notify me when somethings change and then ill go back in the folder to refresh it (manually haha)..
Hi rbalza
well, a manual change after an automatic information is better than nothing... (just kidding)
Unfortunately, I do not have a lot of experiences with Power Automate, but from I would be really surprised, if it does not work on Sharepoint files. I hope, some other readers have more answers for you.
