I need excel to get data from an external sheet.

I've managed to work the formula and everything into it and it works perfectly on my machine.

However, my manager uses a laptop instead of a desktop and his laptop does not have the same drives mine does, so in the formula i have x:/folder/folder/external sheet, this does not work as my manager has a super drive that contains more than just the x drive data.

Now, in Outlook I can fix this by entering file://company.com/data/Everyone/folder/folder/external sheet and this links to the folder perfectly for both me and my manager. However, in excel this doesn't work.

How can I get a universal link in excel to work?