Here is a summary of the most common choices used in presentations.įor an Internet hyperlink, choose the type of hyperlink (choose between Web, FTP or Telnet), and enter the required web address (URL).įor a Mail and News hyperlink, specify whether it is a mail or news link, the receiver address and for email, also the subject.įor a Document hyperlink, specify the document path (the Open File button opens a file browser) leave this blank if you want to link to a target in the same spreadsheet.
#Disable links in excel spreadsheet full
A full description of all the choices, and their interactions, is beyond the scope of this chapter. The top right part of the dialog changes according to the choice made for the hyperlink category from the left panel. New document: the hyperlink creates a new document.Document: the hyperlink points to a place in either the current document or another existing document.Mail & News: the hyperlink opens an email message that is pre-addressed to a particular recipient.Internet: the hyperlink points to a web address, normally starting with.On the left hand side, select one of the four types of hyperlinks: Hyperlink dialog showing details for Internet links Don’t be alarmed when it does this even when you have chosen a relative hyperlink - this 'absolute' target address will be updated if you move the file.
To change the way that OOo saves the hyperlinks in your file, select Tools > Options > Load/Save > General and choose if you want URLs saved relatively when referencing the File System, or the Internet, or both.Ĭalc will always display an absolute hyperlink. For instance, if you have two spreadsheets in the same folder linked to each other and you move the entire folder to a new location, a relative hyperlink will not break. A relative link will stop working only if the start and target locations change relative to each other.
#Disable links in excel spreadsheet how to
Hyperlinks can be stored within your file as either relative or absolute.Ī relative hyperlink says, Here is how to get there from where you are now (meaning the folder in which your current document is saved) while an absolute hyperlink says, Here is how to get there no matter where you start from.Īn absolute link will stop working only if the target is moved.