Query can't use data from file which is open

[-marie-]

Hi All,

i try to get data from an opened file to my query, but it shows, that "it is being used by another process", so i can't do this. 

How do i allow Query to use data from opened filed?

Details: 

I've got one file "Liste.xlsx", Password-Protected on an SharePoint. I've got my "Query.xlsx" on another SharePoint.

The "Query.xlsx" shall read information from my data source "Liste.xlsx". 

I open it via VBA and then i want my Query to refresh, after all i wanted to close the workbook again to keep it all the time protected. 

Does anyone have an idea why it can't be used while file is open?

[otravers]

Have a look at this video:

https://www.youtube.com/watch?v=ssqVE3tshXI

[-marie-]

Hi @otravers

the video described another problem: when you want to do a refresh in a protected sheet in the same file. But my problem is, that i have an protected file (which i unprotect by using VBA), but then can't be reefreshed anymore, "beacause it is being used by another process"

Best regards Marie

[otravers]

That other file needs to be closed (i.e. not open in Excel) while PQ is querying it.