XL2000: Invalid Site Error Using Relative Hyperlink Path

ID: Q211571

The information in this article applies to:

Microsoft Excel 2000

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:

The Address Is Not Valid

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.

REFERENCES

For more information about creating hyperlinks, click Microsoft Excel Help on the Help menu, type create a hyperlink in the Office Assistant or the Answer Wizard, and then click Search to view the topic.

Additional query words: www ftp link XL2000

Keywords : kbnetwork
Version : WINDOWS:2000
Platform : WINDOWS
Issue type : kbprb