Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 10
Default Keep the absolute path in a huperlink

When I add a hyperlink i always add the hyperlink as the document is on
another shared drive. The link path keeps reverting to the format:

...\..\

and loses the link

Any ideas how I can keep the absolute path?
--
Nicola
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Keep the absolute path in a huperlink

If you're using Insert|hyperlink, try changing the base address:

File|Properties|summary tab (near the bottom of the dialog)

(Point at the C:\ folder--it should be available for all users????)

But I've never had any trouble using the =hyperlink() worksheet formula.

=hyperlink("file:////c:\my documents\word\doc1.doc","Click Me")

Nicola wrote:

When I add a hyperlink i always add the hyperlink as the document is on
another shared drive. The link path keeps reverting to the format:

..\..\

and loses the link

Any ideas how I can keep the absolute path?
--
Nicola


--

Dave Peterson
Reply
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
Absolute Path change ... Sige Excel Discussion (Misc queries) 5 February 6th 06 03:10 PM
how to change absolute path to relative path hwijgerse Excel Worksheet Functions 0 November 25th 05 07:18 AM
Link a cell to another workbook with a different path Jai Excel Worksheet Functions 3 August 1st 05 02:05 AM
Absolute vs Relative path K2H Excel Discussion (Misc queries) 2 July 28th 05 12:50 PM
How do link to a remote worksheet using the path value in a field? Michael T. Links and Linking in Excel 3 December 11th 04 08:45 AM


All times are GMT +1. The time now is 02:23 PM.

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

About Us

"It's about Microsoft Excel"