Show All

Hide All

You can insert one or more external reference links from a workbook to another workbook that is located on your intranet (intranet: A network within an organization that uses Internet technologies (such as the HTTP or FTP protocol). By using hyperlinks, you can explore objects, documents, pages, and other destinations on the intranet.) or on the Internet. The workbook must be in Microsoft Excel Workbook Format (.xls) rather than a workbook that has been saved as an HTML (HTML: The standard markup language used for documents on the World Wide Web. HTML uses tags to indicate how Web browsers should display page elements such as text and graphics and how to respond to user actions.) file.

1. Open the source workbook and select the cell or cell range that you want to copy.
2. Click Copy .
3. Switch to the worksheet that you want to place the information in, and then click the cell where you want the information to appear.
4. On the Edit menu, click Paste Special.
5. Click Paste link.

   Excel creates an external reference link for the cell or each cell in the cell range.

Note  You may find it more convenient to create an external reference link without opening the workbook on the Web. For each cell in the destination workbook where you want the external reference link, click the cell, and then type an equal sign (=), the URL (Uniform Resource Locator (URL): An address that specifies a protocol (such as HTTP or FTP) and a location of an object, document, World Wide Web page, or other destination on the Internet or an intranet, for example: http://www.microsoft.com/.) address, and the location in the workbook. For example:

• ='http://www.someones.homepage/[file.xls]Sheet1'!A1
• ='ftp.server.somewhere/file.xls'!MyNamedCell