Sharing excel on google drive: relative path in formula

[Baire]

Hi,

I've got a number of excel-files on Google Drive, which contain a number of formulas. These formulas refer to my C-drive (e.g. =CONCATENATE("accessoires";",";VLOOKUP('C:\Users\Bart\Google Drive\Webshop\...)). I friend of mine has access to this Google Drive, but when he opens the excel none of the values are shown because the formula refers to my C-drive.

Is there a way to insert a relative path that refers to the Google Drive and not my C-drive? If so: how can this be done?

Thx!
Baire

[Baire]

Anybody? I really need to get this fixed!