Forum Discussion
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? ...
Have a look at this video:
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.