How to specify Absolute/Relative Worksheet/book reference values in Excel?
<p>When referencing to another worksheet/book in Excel, is it always linked to a file on a specific hard drive (absolute) - or can be relative, looking in a certain folder, regardless of whether that folder is on computer A, B, or a cloud?</p>

<p>I’m guessing its probably absolute - though is there any way to change to relative?</p>

<p>I’m looking to design a series of templates with multiple interconnected workbooks, to be hosted on a cloud. Won’t work if the reference values are absolute - so need relative values so when linking to the other workbooks, Excel will be looking in the relative folder.</p>

<p>thanks!!</p>