Linking vs. Hyperlinking
Hyperlinks, discussed in Chapter 30, 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 that Excel still finds ...
Get Microsoft® Excel® 2010 Inside Out now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
