An absolute hyperlink will stop working only if the target is moved. A relative hyperlink will stop working only if the source and target locations change relative to each other. Suppose, 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 link.