Linking vs. Hyperlinking
Hyperlinks, discussed in Chapter 29, are an alternative way to connect an Excel document to an external file. If you want your Excel document to reference supplementary information without making that information obtrusive, you can do it neatly with a hyperlink.
Which method you prefer is likely to be a matter of taste. Most people looking at your Excel document will find a hyperlink self-explanatory, but some might not know immediately how to use an OLE link. On the other hand, an iconic OLE link might more easily grab a viewer’s attention. OLE links are also self-repairing—in some cases, at least. (If you rename or move a target of an OLE link, Windows can sometimes update the link information so Excel still finds the ...
Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Read now
Unlock full access