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