Microsoft KB Archive/211571

= XL2000: Invalid Site Error Using Relative Hyperlink Path =

Article ID: 211571

Article Last Modified on 11/5/2003

-

APPLIES TO


 * Microsoft Excel 2000 Standard Edition

-



This article was previously published under Q211571





SYMPTOMS
When you click a hyperlink, you may receive the following error message:

The address of this site is not valid.

Check the address and try again.



CAUSE
This behavior occurs when the hyperlink is unable to find the specified address. The hyperlink may not be able to find the address for one of the following reasons:
 * The address is not valid.
 * You did not save the workbook before inserting a hyperlink with a relative path.



WORKAROUND
To work around this behavior, use one of the following methods:

Method 1
If the address is a World Wide Web internet address, such as www.server/share/filename.xls, where server is the Web server name, share is the name of the share on the server, and filename.xls is the name of a workbook, check that the address is valid with a Web browser such as Microsoft Internet Explorer.

Method 2
If the address belongs to an intranet network, verify the address by clicking Open on the File menu, and entering the target file by using the universal naming convention (UNC) to map to the share where the target file is located. For example, use the following convention

\\server\share\filename.xls

where server is the Web server name, share is the name of the share on the server, and filename.xls is the name of a workbook.

The Hyperlink Contains a Relative Path
If you failed to save the workbook before you created the hyperlink, save the workbook, and then reinsert the hyperlink.

Microsoft recommends that you save the workbook before you create a hyperlink. In order for Microsoft Excel to create a relative path, a base address must be computed; saving the workbook creates this base address.

