Excel Power Queries break when updating source files

asked 2022-06-29T22:54:09.053+00:00
Alex 1 Reputation point

I do a lot of work using power query in excel. I extract data from hundreds of files inside source folders on a shared server. The program keeps breaking (and is not recoverable saying the query lost connection) on me when I update the files inside a source folder (delete the old and paste in current). Is there a way to prevent this from happening?

Not Monitored
Not Monitored
Tag not monitored by Microsoft.
23,731 questions
{count} votes