Refreshing a Power Query table while a user is in the source file

[DrCheese1023]

Hi all, I've made massive headway in what I'm trying to set up in finding Power Query. What I'm trying to do is create a backend Excel sheet that compiles the information from multiple frontend workbooks in a folder. Easy-peasy, however, I cannot refresh the backend while any of the source files are open, which is a big problem because I need the information that my employees are entering in real time. How can I get around this without making everyone close the source books?

 

[Alex Blakenburg]

Are you using From Files > from Folder ?
If so are you filtering out files that start with "~$" ?

 

[DrCheese1023]

Are you using From Files > from Folder ?
If so are you filtering out files that start with "~$" ?

if i did that it wouldnt be updating the open workbooks, which doesnt help the real time aspect

 

[Alex Blakenburg]

Fair enough. Sorry I don't have an answer. Hopefully someone else on the forum knows.
You might want to describe what its doing when you try to refresh from an open workbook.