View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.misc
Worthy
 
Posts: n/a
Default How do I display the full file path for a hyperlink in Office

Thanks - I've tried that but I can't point the hyperlink to where the reports
are stored if the drive is disconnected.


--
Paul


"Gary''s Student" wrote:

Try to dis-connect networked drives before entering the hyperlink.
--
Gary''s Student


"Worthy" wrote:

I am writing user manuals for a series of reports I produce and I'm using
hyperlinks to show where reports are stored. When I insert the hyperlink it
loses the full name of the file path and replaces it with the drive letter
that the report is stored on. (i.e. instead of
\\uup-rep-dx89\MI_Reports\daily\test.xls the hyperlink is shown as
E:\MI_Reports\daily\test.xls.)

Although the hyperlink will still work, it is not very practical for
somebody to follow the user manual if they have a print out because network
drives can be mapped to different drive letters.

Hope this makes sense and hope somebody can help!

Cheers