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.
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