Power Query won't load because file being used by another person

[Carol1120]

I have one Excel workbook with multiple worksheets which is the source for a power query in another Excel Workbook. The Source workbook is a shared file and when anyone is in the file the power query will not update. How do I get the query to update when the other file is open? 

[#2]

Hi @Carol1120 

as far as I know, there is no way to update a Power Query when the source file is open.

[#3]

@Carol1120 

Save file as read only  (shared files should be saved as read only) unless the maintainer is updating the file contents)