Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old August 26th 08, 09:10 AM posted to microsoft.public.excel.worksheet.functions
EM EM is offline
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2007
Posts: 7
Default How do I stop "global" hyperlinks changing to "local" links?

I am creating a series of spreadsheets which are used by multiple users on
different computers. When we create the links we use a "global" reference
referring to the server name:

\\server_name\Directory 1\Directory 2\document name.doc

However, once someone clicks on the link it defaults to a "local" link to
where they have mapped the drive, eg.

......\Directory%202\document%20name.doc

This means that if the document is save the link dose not work from another
computer.

How do you stop excel chanding the hyperlink you insert?

  #2   Report Post  
Old August 26th 08, 11:06 AM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 11,058
Default How do I stop "global" hyperlinks changing to "local" links?

Try the HYPERLINK() function:

=HYPERLINK("file:///\\server_name\Directory 1\Directory 2\document name.doc")
--
Gary''s Student - gsnu200801


"Em" wrote:

I am creating a series of spreadsheets which are used by multiple users on
different computers. When we create the links we use a "global" reference
referring to the server name:

\\server_name\Directory 1\Directory 2\document name.doc

However, once someone clicks on the link it defaults to a "local" link to
where they have mapped the drive, eg.

.....\Directory%202\document%20name.doc

This means that if the document is save the link dose not work from another
computer.

How do you stop excel chanding the hyperlink you insert?

  #3   Report Post  
Old August 26th 08, 01:18 PM posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 35,218
Default How do I stop "global" hyperlinks changing to "local" links?

A few people have said that this has resolved the problem for them:

File|Properties|Summary Tab|Hyperlink Base
change it to C:\
(something that's always available)

I like to use the =hyperlink() worksheet function. It has never failed me this
way:

=hyperlink("file:////yourpathtothe/something.xxx","Click me")

==============
If you have to change lots and lots and lots back...

You could use the code from David McRitchie's site:

http://www.mvps.org/dmcritchie/excel/buildtoc.htm
look for:
Fix Hyperlinks (#FixHyperlinks)

If you're new to macros, you may want to read David McRitchie's intro at:
http://www.mvps.org/dmcritchie/excel/getstarted.htm

(If it's just a few, I'd do it manually.)

Em wrote:

I am creating a series of spreadsheets which are used by multiple users on
different computers. When we create the links we use a "global" reference
referring to the server name:

\\server_name\Directory 1\Directory 2\document name.doc

However, once someone clicks on the link it defaults to a "local" link to
where they have mapped the drive, eg.

.....\Directory%202\document%20name.doc

This means that if the document is save the link dose not work from another
computer.

How do you stop excel chanding the hyperlink you insert?


--

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
Excel - Golf - how to display "-2" as "2 Under" or "4"as "+4" or "4 Over" in a calculation cell Steve Kay Excel Discussion (Misc queries) 2 August 8th 08 01:54 AM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Count occurences of "1"/"0" (or"TRUE"/"FALSE") in a row w. conditions in the next BCB New Users to Excel 7 May 13th 06 10:02 PM
create links to check boxes marked "good" fair"and "bad" pjb Excel Worksheet Functions 3 April 20th 06 02:17 AM
Changing "returned" values from "0" to "blank" LATATC Excel Worksheet Functions 2 October 20th 05 04:41 PM


All times are GMT +1. The time now is 06:17 AM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017