Microsoft KB Archive/189155

= XL98: Unable to Use File URL in Linking Formulas =

Article ID: 189155

Article Last Modified on 9/11/2002

-

APPLIES TO


 * Microsoft Excel 98 for Macintosh

-



This article was previously published under Q189155





SYMPTOMS
If you try to enter a linking formula in a cell using a File URL format, the formula will return the #REF! error.



CAUSE
Microsoft Excel 98 Macintosh Edition only supports Internet links using either the HTTP URL or the FTP URL formats.



RESOLUTION
If you know the path to the file and have connected to the server using Chooser, you can create a formula link. The following is an example of a formula link:

='share:[bookname]Sheet1'!A1



MORE INFORMATION
The following linking formulas are examples of how you can manually create Internet links in Microsoft Excel to HTTP or FTP servers:

HTTP
='http://webserver/webpage/[bookname]Sheetname'!A1

When you enter this formula, it may initially resolve to the #REF! error value, but after a few seconds, the source cell value will display in the linked cell.

FTP
='ftp://server/[bookname]Sheetname'!A1

