Hello,

I am having some issues with importing data via MS Query to another workbook while on Google Drive.

I have two workbooks for my operation. One workbook has a list of all my products, the second is an invoicing template.
I select an item number in the invoice and it matches & index a table from the product list and fills in. I currently use MS query so that I don't have to open up two files to update the table.

The problem occurs when another user tries to use the worksheet. The Google Drive directory is username/Google Drive/... and because of this when a different user opens the file the link breaks. Is there any workaround for this?

Much appreciation in advance.