Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Have a look at this video:
https://www.youtube.com/watch?v=ssqVE3tshXI
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
That other file needs to be closed (i.e. not open in Excel) while PQ is querying it.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
101 | |
49 | |
19 | |
12 | |
11 |