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

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...