Forum Discussion

-marie-'s avatar
-marie-
Frequent Visitor
4 years ago

Query can't use data from file which is open

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?

 

Need Help

3 Replies

    • -marie-'s avatar
      -marie-
      Frequent Visitor
      4 years ago

      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's avatar
        otravers
        Community Champion
        4 years ago

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