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.