Prevent hyperlinks updating
Link_location can refer to a place in a document — such as a specific cell or named range in an Excel worksheet or workbook or to a bookmark in a Microsoft Word document.The path can be to a file stored on a hard disk drive.By default, unspecified paths to hyperlink destination files are in relation to the location of the active workbook.By default, you can set a different base address to use so that every time that you create a hyperlink to a file in that location.For example, if the active worksheet is the sheet named June in the workbook named Budget, the following formula creates a hyperlink to cell E56. To jump to a different sheet in the same workbook, change the name of the sheet in the link.In the previous example, to create a link to cell E56 on the September sheet, change the word "June" to "September." Top of Page You can insert one or more external reference (also named links) from a workbook to another workbook that is located on your intranet or on the Internet. By default, unspecified paths to hyperlink destination files are in relation to the location of the active workbook.The cell on the worksheet that contains the hyperlink displays the contents of cell D1 as the jump text: The following example creates a hyperlink to the range named Dept Total on the worksheet named First Quarter in the workbook Budget Report.xlsx, which is stored on the Internet at the location named example.microsoft.com/report.The cell on the worksheet that contains the hyperlink displays the text "Click to see First Quarter Department Total": To create a hyperlink to a specific location in a Word document, you must use a bookmark to define the location in the document that you want to jump to.
Each time that you create a hyperlink to a file in that location, you have to specify only the file name, not the path, in the Insert Hyperlink dialog box.For quick access to related information in another file or on a web page, you can insert a hyperlink in a Microsoft Excel worksheet cell.You can also insert hyperlinks in specific chart elements or images.Friendly_name The jump text or numeric value that is displayed in the cell. If friendly_name is omitted, the cell displays the link_location as the jump text.The following example creates a hyperlink to cell F10 on the worksheet named Annual in the workbook Budget Report.xlsx, which is stored on the Internet at the location named example.microsoft.com/report.