Hyperlink stored in an external workbook

[Tony Starr]

I have a situation where I have a central workbook called "shared" which is
used to maintain links to policy documents. The "shared" workbook is
referenced by hundreds of user workbooks that need to have a hyperlink to
the latest policy document.

In each of my user workbooks I set cell a1 = Shared!mPolicy1 where mPolicy1
is a hyperling to a word doucument.
In cell b1 of my user workbook I have the formula =Hyperlink(a1).

This works nicely.
The problem is if the hyperlink stored in mPolicy1 of the shared workbook
contains a subaddress the following error occurs when clicking on b1 in the
user workbook

"Cannot open the specified file".

Any idea how I can implement the hyperlinks with subaddresses?

TIA
Tony

 

[Guest]

I:
1. entered:
file:///c:\documents and settings\owner\desktop\ballon.doc
in cell C3 in Shared.xls

2. named C3 as mPolicy1

3. entered:
= Shared.xls!mPolicy1
in cell A1 in user.xls
( this displayed that same hyperlink, but was "cold")

4. entered:
=Hyperlink(A1)
in cell A2 in user.xls
( same display, but "clickable")

Word doc opens with no problem.