Hyperlinks

[Eileen Jeffree]

I have a spreadsheet with a series of hyperlinks pointing
to .pdf & .doc files on the same server as the spreadsheet.
It seems at random that some hyperlinks stop working and I
receive either "The address of this site is not valid.
Check the address and try again." or "Cannot open the
specified file" error messages. When I recreate the
hyperlink back to the same file, it works fine but I don't
want to keep doing this for hundreds of links.
Any ideas on how to preserve these links?
There are spaces in the filepath - but I didn't think that
would be a problem.

 

[David McRitchie]

Hi Eileen,
If it is only the ones with spaces with the problem try substituting %32 for a space.

--

 

[Guest]

thanks for the tip, but unfortunately no joy. Is there
anything else other than spaces that could be the issue?

-----Original Message-----
Hi Eileen,
If it is only the ones with spaces with the problem try

substituting %32 for a space.wrote in message [email protected]...

 

[David McRitchie]

Could you show what some of your invalid hyperlinks looks like
and some of the valid hyperlinks so that we know what we are
actually working with. Are they in cells, are they the entered
from right click on cell and then hyperlink.

thanks for the tip, but unfortunately no joy. Is there
anything else other than spaces that could be the issue?

-----Original Message-----
Hi Eileen,
If it is only the ones with spaces with the problem try

substituting %32 for a space.wrote in message [email protected]...

.

 

[Eileen]

David,

All hyperlinks have been created using the Insert -
Hyperlink option & I've browsed to find the file to avoid
typing mistakes.
(it's inserted "%20" for each space in the filename)
The following ones don't work:
.../../Human%20Resources/HR%2002-05.doc
.../../../../wan/Corporate%20Forms/Human%20Resources/HR%
2004-01.pdf

The following ones do work :
.../Human%20Resources/HR%2001-02.doc
.../Human%20Resources/HR%2001-01.pdf
(I redid these two today after finding out they didn't
work)
.../OHSW/OHS%2009-07.doc (this one has always worked)

The complete filepath is:
\\ho03\wan\Corporate Forms\Human Resources\..............
The users are mapped as:
M:\Corporate Forms\Human Resources\.........

But the beginning of the filepath seems to be changing.

Thanks for your help.

-----Original Message-----
Could you show what some of your invalid hyperlinks looks like
and some of the valid hyperlinks so that we know what we are
actually working with. Are they in cells, are they the entered
from right click on cell and then hyperlink.

thanks for the tip, but unfortunately no joy. Is there
anything else other than spaces that could be the issue?

-----Original Message-----
Hi Eileen,
If it is only the ones with spaces with the problem try

substituting %32 for a space.wrote in message [email protected]...

I have a spreadsheet with a series of hyperlinks pointing
to .pdf & .doc files on the same server as the spreadsheet.
It seems at random that some hyperlinks stop working and I
receive either "The address of this site is not valid.
Check the address and try again." or "Cannot open the
specified file" error messages. When I recreate the
hyperlink back to the same file, it works fine but I don't
want to keep doing this for hundreds of links.
Any ideas on how to preserve these links?
There are spaces in the filepath - but I didn't think that
would be a problem.


.

.

 

[David McRitchie]

Hi Eileen,
Yes I meant %20 for space, glad you understood what it was.

You may have already solved your own problem by reading what
you wrote, but looks to me like you have an extra ../
in the one's that don't work. This is the notation as used
in HTML webpages for <a href="....
and like when you work from the Command Window (DOS commands)
with your directory. Perhaps you removed a directory level at one
time.

Another thing that might come into play is in your file, properties,
summary, hyperlink base:
if you don't have it, I certainly wouldn't add it, except for experimenting
or when you know you need it. Would work same as <BASE ...
in HTML. Relative URL or Relative URI in http://www.ietf.org/rfc/rfc1808.txt
one of those mentioned in
12.4 Path information: the BASE element
http://www.w3.org/TR/REC-html40/struct/links.html#edef-BASE
12.4.1 Resolving relative URIs

Also check your Excel helpfile
Help (F1), Answer Wizardtab), relative hyperlink

David,

All hyperlinks have been created using the Insert -
Hyperlink option & I've browsed to find the file to avoid
typing mistakes.
(it's inserted "%20" for each space in the filename)
The following ones don't work:
../../Human%20Resources/HR%2002-05.doc
../../../../wan/Corporate%20Forms/Human%20Resources/HR%
2004-01.pdf

The following ones do work :
../Human%20Resources/HR%2001-02.doc
../Human%20Resources/HR%2001-01.pdf
(I redid these two today after finding out they didn't
work)
../OHSW/OHS%2009-07.doc (this one has always worked)

The complete filepath is:
\\ho03\wan\Corporate Forms\Human Resources\..............
The users are mapped as:
M:\Corporate Forms\Human Resources\.........

But the beginning of the filepath seems to be changing.

Thanks for your help.

-----Original Message-----
Could you show what some of your invalid hyperlinks looks like
and some of the valid hyperlinks so that we know what we are
actually working with. Are they in cells, are they the entered
from right click on cell and then hyperlink.

thanks for the tip, but unfortunately no joy. Is there
anything else other than spaces that could be the issue?

-----Original Message-----
Hi Eileen,
If it is only the ones with spaces with the problem try
substituting %32 for a space.

--
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed
Nov. 2001]
My Excel Pages:
http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page:
http://www.mvps.org/dmcritchie/excel/search.htm

"Eileen Jeffree" <[email protected]>
wrote in message [email protected]...
I have a spreadsheet with a series of hyperlinks
pointing
to .pdf & .doc files on the same server as the
spreadsheet.
It seems at random that some hyperlinks stop working
and I
receive either "The address of this site is not valid.
Check the address and try again." or "Cannot open the
specified file" error messages. When I recreate the
hyperlink back to the same file, it works fine but I
don't
want to keep doing this for hundreds of links.
Any ideas on how to preserve these links?
There are spaces in the filepath - but I didn't think
that
would be a problem.


.

.

 

[Dave Peterson]

There's an option under:
File|Properties|Summary Tab

You could try putting something (not the actual location) in the hyperlink base
(maybe c:\).

And see if that fixes the problem.

==
Another alternative, I've never seen break is the =hyperlink() worksheet
function.

=hyperlink("http://yourURL/filename.xls")