Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel hyperlink loses its path on save (2)

I have a Hyperlink in my worksheet that points to a document on our network
server, but when I save this file and email it to the group the hyperlink
changes to point to my hard drive where the document is not located.

Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel hyperlink loses its path on save (2)

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.


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

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


George R. wrote:

I have a Hyperlink in my worksheet that points to a document on our network
server, but when I save this file and email it to the group the hyperlink
changes to point to my hard drive where the document is not located.

Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.


--

Dave Peterson
  #3   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel hyperlink loses its path on save (2)

In properties, I changed it to point to the subfolder on the network server
where the hyperlinked document is located (not C, which is my local hard
drive as this didn't work). So far this seems to work. I apreciate this
suggestion as well as the hyperlink formula approach as well!

"Dave Peterson" wrote:

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.


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

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


George R. wrote:

I have a Hyperlink in my worksheet that points to a document on our network
server, but when I save this file and email it to the group the hyperlink
changes to point to my hard drive where the document is not located.

Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.


--

Dave Peterson

  #4   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel hyperlink loses its path on save (2)

I would have guessed that the C: would work better. It's worked for quite a few
other people.

But I really like the =hyperlink() worksheet function. That never fails <vbg.

George R. wrote:

In properties, I changed it to point to the subfolder on the network server
where the hyperlinked document is located (not C, which is my local hard
drive as this didn't work). So far this seems to work. I apreciate this
suggestion as well as the hyperlink formula approach as well!

"Dave Peterson" wrote:

A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.

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

In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change the hyperlink base on the Summary tab.


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

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


George R. wrote:

I have a Hyperlink in my worksheet that points to a document on our network
server, but when I save this file and email it to the group the hyperlink
changes to point to my hard drive where the document is not located.

Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.


--

Dave Peterson


--

Dave Peterson
  #5   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default Excel hyperlink loses its path on save (2)

On Jun 15, 9:06*pm, Dave Peterson wrote:
I would have guessed that the C: would work better. *It's worked for quite a few
other people.

But I really like the =hyperlink() worksheet function. *That never fails <vbg.



George R. wrote:

In properties, I changed it to point to the subfolder on the network server
where the hyperlinked document is located (not C, which is my local hard
drive as this didn't work). *So far this seems to work. *I apreciate this
suggestion as well as thehyperlinkformula approach as well!


"Dave Peterson" wrote:


A few people have said that this has stopped a similar problem from occurring.
Maybe it'll help you--but you'll have to test it to make sure.


In xl2003 menus:
File|Properties|Summary Tab|HyperlinkBase
change it to C:\
(something that's always available)


In xl2007:
Click on the Office button
Choose Prepare, then properties.
Then use the arrow on the Document Properties dropdown
Choose Advanced Properties
And then change thehyperlinkbase on the Summary tab.


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


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


George R. wrote:


I have aHyperlinkin my worksheet that points to a document on our network
server, but when I save this file and email it to the group thehyperlink
changes to point to my hard drive where the document is not located..


Tools - Options - General - Web Options - Files - Uncheck update links
on save doesn't work. * Also, I erased the file default location as this was
pointing to my hard drive; this seemed to work for awhile but not any more.


--


Dave Peterson


--

Dave Peterson


Hi

I've tried to use the =hyperlink function in excel 2002 but I'm not
sure how the pathname should be written.

We have two computers on a network, imaginatively named PC1 & PC3 (PC2
was retired sometime ago). An excel file sites on PC1, as do the
documents we want to link to. We need to be able to open the excel
file and the links from PC3. Both relative file paths and setting the
file root in excel have not worked. I saw that the =hyperlink function
was suggested as a solution to similar problems and thought I'd give
it a shot.

I have tried a variety of pathnames in the =hyperlink function but
always receive the error "Cannot open the specified path".

I searched the web but couldn't find anything that described how to
write the file path correctly in excel. Can anyone tell me the correct
syntax?

Cheers

David


  #6   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 35,218
Default Excel hyperlink loses its path on save (2)

If those files that you're hyperlinking to exist on the individual pc's, I
_THINK_ you'll have to do some folder sharing. And then you could use those
shared folders on the other pcs.

You may want to ask in a forum dedicated to windows (include your version in
your question).

But it may be easier to find a network drive (are you on a network???) and
create a share that all of the pc's can access. Then you can use the UNC path
or even map the share and use a drive letter in the =hyperlink() formula:

=hyperlink("\\share\path\filename.xls","Click me")
or
=hyperlink("m:\filename.xls","click me")



Davva wrote:
<<snipped
Hi

I've tried to use the =hyperlink function in excel 2002 but I'm not
sure how the pathname should be written.

We have two computers on a network, imaginatively named PC1 & PC3 (PC2
was retired sometime ago). An excel file sites on PC1, as do the
documents we want to link to. We need to be able to open the excel
file and the links from PC3. Both relative file paths and setting the
file root in excel have not worked. I saw that the =hyperlink function
was suggested as a solution to similar problems and thought I'd give
it a shot.

I have tried a variety of pathnames in the =hyperlink function but
always receive the error "Cannot open the specified path".

I searched the web but couldn't find anything that described how to
write the file path correctly in excel. Can anyone tell me the correct
syntax?

Cheers

David


--

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
Hyperlink to File name and path VBA Excel jlclyde Excel Discussion (Misc queries) 3 February 4th 09 07:24 PM
Excel hyperlink loses its path on save Riptide55 Excel Discussion (Misc queries) 2 November 26th 08 05:35 PM
hyperlink navigation path path wrong in Excel 2003 CE Admin Excel Discussion (Misc queries) 5 January 7th 06 07:47 PM
find and replace path name in Excel cells containing hyperlink leoe Excel Discussion (Misc queries) 1 August 9th 05 08:57 PM
Hyperlink loses reference Jami's Mom Excel Worksheet Functions 0 December 16th 04 08:23 PM


All times are GMT +1. The time now is 09:21 AM.

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

About Us

"It's about Microsoft Excel"