How to Link to a Local File in Office 2011 for Mac - dummies

How to Link to a Local File in Office 2011 for Mac

By Geetesh Bajaj, James Gordon

One of the most useful tools in all of Office 2011 for mac is the ability to make hyperlinks to just about anywhere. You can link to any file on your computer; these files are local files. To link to local files, you can use two kinds of links:

  • Absolute: This kind of link contains the entire file path to your content. The URL starts with file://localhost/Users/ and links to a file anywhere on your computer. This kind of URL works only for a single-user account. If you move the document, workbook, or presentation to another computer, the hyperlink won’t work.

    Use this kind of link only if you know your link will never have to work on another computer.

  • Relative: A relative link contains only the filename of content that is linked within the same folder (at the same directory level) as the document, workbook, or presentation before you make the link.

    If you copy the folder itself that contains the document, workbook, or presentation file that also contains the content file, you can put the copy of the entire folder onto any media such as a flash drive, CD, or DVD, and the link will work on any computer.

To set up your document to make a copy that can be distributed with relative hyperlinks, take these steps:

  1. Press Command-S, or click the Save button on the Standard toolbar to save your document in its current location.

  2. Choose File→Save As and click the New Folder button to make the folder that will contain your document and content prior to linking.

  3. Save a copy of your document, workbook, or presentation in the new folder.

  4. Make copies of your content: In Finder, Option-drag copies of any content you want to link to into the folder.

    Now you can make links (following the directions in the next section) to the content that you put into the shared folder.

To hyperlink to a local file on your computer, here’s what you do:

  1. Display the Insert Hyperlink dialog by right-clicking selected text or an object and then choosing Hyperlink from the pop-up menu, or press Command-K.

  2. Click the Document tab.


  3. Click the Select button.

  4. Choose a file and then click Open to create the link and close the dialog.

  5. (Optional) Click the ScreenTip button to display a dialog where you can type a ScreenTip that appears when someone hovers a mouse pointer over the hyperlink.

  6. (Optional) Click the Locate button.

    If the Web page has anchors (bookmarks), the Select Place in Document dialog displays and lists the anchors. If you’re linking to a Word document, a list of bookmarks displays. If you’re linking to an Excel workbook, you can link to a sheet name, named range, or named object. PowerPoint offers a list of slides to link to.

    Choose a bookmark from the list in the Select Place in Document dialog and then click OK to close it.

  7. Click OK to close the Insert Hyperlink dialog.

    The hyperlink displays.