Jul 13 2022 06:59 PM
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 :)
Jul 13 2022 11:33 PM
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.
Jul 13 2022 11:47 PM
Jul 13 2022 11:52 PM
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.
Jul 15 2022 11:51 PM