A while ago my team and I faced this similar situation. I have not found a perfect solution, but it has resolved with a new refresh on my side. You can refer this Workbook asking to "Locate the Extract" every day. discussion of mine with experts here.
Please check to see if your colleague does have permission(read/write/execute) to access the dropbox folder where you have your workbook and extract. Also, you can locate the extract, save the workbook and make a refresh once, on your machine(If it doesnot prompt you to locate the extract). By doing this on your machine, it may not prompt your colleague to locate the extract.
Please share if you find a solution in future, it will be helpful.
Hope this helps.