ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Keep the absolute path in a huperlink (https://www.excelbanter.com/excel-discussion-misc-queries/97543-keep-absolute-path-huperlink.html)

Nicola

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

Dave Peterson

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


All times are GMT +1. The time now is 10:00 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com