How do I make a relative reference to another workbook in Excel?
===

I am producing a sheet to calculate prices. The sheets has to have a reference to several other workbooks to get the prices for different components. This works fine on my computer but when I move them to the server or another computer, it can't find the references.

My folder is structured like:

    Folder
    |-- prices.xlsx
    |-- Fixed Components
    |   |-- ComponentsA.xlsx
    |	+-- ComponentsB.xlsx
    |
    +-- Variable Components
        |-- ComponentsC.xlsx
        +-- ComponentsD.xlsx

the prices.xlsx is the main sheet that references the other sheets. On my computer it builds the references with an absolute path, so when I copy the files the path stays fixed to my machine, instead of referencing the the files on the other pc.

Is there any way to make the references relative so that I can put in the main sheet something like ='\Variable Components\[ComponentsC.xlsx]Sheet1'!A1 . I would not want to use VBA for this as people don't tend to trust Macros and then complain the functions don't work.

Many Thanks in advance!
	