Relative workbook references?
 

Hi - at my company we use a version control system for our documents.
We manually update versions on our desktop. If I create a spreadsheet
that references another working copy, then check it back into version
control, and then another person opens it up, the formula references
the working copy of the sheets on my desktop. Is there anyway to
change it so it would reference the working copy on the second
person's desktop? Thanks.