I have created a Workbook(A) which extracts data from different workbooks(B to G) by using MS Query and stores in Workbook (A)

Workbook(A) is sitting on Server A.

Workbooks (B to G) are located on N, O, P, Q, R, S i.e. 6 different servers on 6 different locations in 6 different cities.

Workbook(A) has a macro assigned to run the MS Query (Refresh all)

I am connected to Server A and so as my colleague.

Workbook (A) is saved in a folder to which both of us have same access rights to alter, modify etc. all the files.

I can always use macro to refresh all the data and the query runs perfectly fine. However, my colleague encounters a problem and even though can access the file, he is not able to use Macro to refresh and run the query (the error message pertains to path)

I have reached a deadlock and do not have any answer to why. I can fully understand that path problems will come for my colleagues sitting on different servers but I have failed to understand as to why we 2 of us sitting on same server in same folder but my colleague cannot run the query.

Any help would be greatly appreciated.

Ps: I am not technically strong rather a DIY person.