Microsoft Query Question

[daveburke114]

Hello to the forum!

Just a quick question following on from a different thread.

I'm (now) using MS Query to pull data from other sheets into a master workbook.

I was just wondering on the behaviour of the link.

For example I have all the Source Workbooks and Master Workbook in one folder on my laptop.

That folder is also shared using Dropbox with my desktop computer and my MDs computer.

Will the links still work as the files are still in the same folder regardless of the computer, OR will they break as they will be looking for a location for the files as listed on my laptop

If the latter, how do I make them into relative links
ie
instead of C:/Laptop/Work/Files/source1.xml etc
to
(samefolderasmasterfile)/source1.xml

Thanks
Dave