locked
Absolute/Relative Workbook hyperlinks? RRS feed

  • Question



  • When referencing to another worksheet/book, 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?

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

    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.
    thanks!!
    Saturday, January 2, 2016 9:08 AM

Answers

  • I’m guessing its probably absolute - though is there any way to change to relative?

    Try as follows:

    Create a new file, save as FileA.xlsx in a folder.
    Create a new file, save as FileB.xlsx in a folder.
    Create a hyperlink in FileA.xlsx that refers to cell A1 in FileB.xlsx
    Create a formula in FileA.xlsx that refers to cell A1 in FileB.xlsx
    Save FileA.xlsx
    Close Excel
    Move both files into a different folder
    Open FileA.xlsx
    Have a look at the path in the hyperlink, resp. formula
    Use the hyperlink, calculate the workbook, it works.

    Andreas.

    Saturday, January 2, 2016 11:02 AM