Forum Discussion
Power Query locking when someone opens a separate referenced Pivot table file
I created a power query to import .csv files from a few folders and reformat them / merge data from other files etc. I created a sepearate Pivot table excel file that about 10 managers use to see th...
Either set the file to not refresh on open, or move the CSV files to SharePoint libraries. Those do not cause a lock and multiple apps can read them at the same time. This is one of many reasons I store files in SharePoint vs local network or local PC drives. I never deal with file locks for data source files.