Link to external workbook regardless of user

[Valerie Ho]

I have a cell in Workbook1 that links to the value in Workbook2 in Google Drive. The formula will show the below:

='C:\Users\JaneDoe\Google Drive\ABC Pte Ltd\[Q - VAS-Quote-Current.xlsm]Customer'!A11

When another user using another computer opens the file, it'll show the below (same as above) and will not update to the correct value.

='C:\Users\JaneDoe\Google Drive\ABC Pte Ltd\[Q - VAS-Quote-Current.xlsm]Customer'!A11

Is there anyway I can make it such that it'll reference to the actual workbook2 regardless of users? Preferably without VBA?

Thanks!

[#2]

Where is Workbook1 located? If in the same folder, normally this should work.