title: How do I make a relative reference to another workbook in Excel?
body: <p>I am producing a sheet to calculate prices. The sheet 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.</p>
  
  <p>My folder is structured like:</p>
  
  <pre><code>Folder
  |-- prices.xlsx
  |-- Fixed Components
  |   |-- ComponentsA.xlsx
  |   +-- ComponentsB.xlsx
  |
  +-- Variable Components
      |-- ComponentsC.xlsx
      +-- ComponentsD.xlsx
  </code></pre>
  
  <p><code>prices.xlsx</code> 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.</p>
  
  <p>Is there any way to make the references relative so that I can put in the main sheet something like <code>='\Variable Components\[ComponentsC.xlsx]Sheet1'!A1</code>. 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.</p>