LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #7   Report Post  
Posted to microsoft.public.excel.misc
snicho
 
Posts: n/a
Default How do I display the full file path for a hyperlink in Office 2003

Set the File, Properties, Hyperlink Base to "\\" (without the inverted commas).

This may intitially break a few links (but maybe not), but if you go back
and set all your hyperlinks again to an absolute path on your LAN it should
solve any further broken links.



"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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Why no XML in Excel 2003 with Office Standard? [email protected] Excel Discussion (Misc queries) 0 April 21st 06 10:36 PM
Hyperlink to a location on worksheet and display full image. twilliams Excel Discussion (Misc queries) 1 February 7th 06 10:06 PM
Excel 2003 hyperlink problem. rockbottom Excel Discussion (Misc queries) 0 December 1st 05 06:02 PM
Excel 2003 hyperlink problem. rockbottom Excel Discussion (Misc queries) 0 December 1st 05 05:02 PM
trying to open an excel file in excel 2003 Edward Letendre Excel Discussion (Misc queries) 1 June 3rd 05 02:22 PM


All times are GMT +1. The time now is 10:28 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"