Show All

Insert a formula link to worksheet data on your intranet or the Internet

You can insert a link from a workbook to another workbook that is located on your 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 file.

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

   Note  To create a link without opening the workbook on the Internet, click the cell where you want the link, and type an equal sign (=) and the URL address, followed by the location in the workbook. For example, type ='http://www.someones.homepage/[file.xls]Sheet1'!A1 or ='ftp.server.somewhere/file.xls'!MyNamedCell