Hyperlinks

[Leen]

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

 

[CyberTaz]

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon?

How [step-by-step] are you creating the hyperlink?

What do you mean by "map" - folder, volume, drive...? Is there a network
involved? How lengthy is the path to the target file's location? Do any of
the element names in the path use other than alphanumeric characters?

What version of Word created the target document? What is the file type
(.doc, .docx...)? Is there any VBA used in the document?

What - exactly - is the wording in the error message?

Specific version info for Office might also be helpful.

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Leen]

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon? Yes I can

How [step-by-step] are you creating the hyperlink?

I used the right mouseclick, clicked on Hyperlink -> insert hyperlink,
in other words the common 'wizard'

What do you mean by "map" - folder, volume, drive...? Is there a network
involved? How lengthy is the path to the target file's location? Do any of
the element names in the path use other than alphanumeric characters?

What I meant is the folder of course, a bit of a poor translation.
There's no network involved.
The cell is part of a excel file (xlsx) and the hyperlink refers to a
word docx but in another folder.

What version of Word created the target document?

Word 2008 for Mac, Version 12.1.3 last updat e 12.1.4

What is the file type
(.doc, .docx...)? Is there any VBA used in the document? Docx and Xlsx, no BVA
What - exactly - is the wording in the error message?

"Cannot open the file" after clicking the hyperlink, as translated from Dutch.

 

[Leen]

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon? Yes I can

How [step-by-step] are you creating the hyperlink?

Used right (mighty) mouse click, clicked hyperlink and used the
'wizard' as it comes.

What do you mean by "map" - folder, volume, drive...? Is there a network
involved? How lengthy is the path to the target file's location? Do any of
the element names in the path use other than alphanumeric characters?

No network involved. I meant ofcourse Folder, it was a poor translation
from Dutch
Files are in different folders
Example path:
G4S/Facturen/2008/Factuur%20G4S%202126.1412.08.docx

What version of Word created the target document? Office 2008 for Mac
What is the file type
(.doc, .docx...)? Both xlsx and docx
Is there any VBA used in the document? No

What - exactly - is the wording in the error message?

Just 'Cannot open file' literally transpated from Dutch

Specific version info for Office might also be helpful.

Version 12.1.3, last update 12.1.5

 

[Leen]

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon?

How [step-by-step] are you creating the hyperlink?

What do you mean by "map" - folder, volume, drive...? Is there a network
involved? How lengthy is the path to the target file's location? Do any of
the element names in the path use other than alphanumeric characters?

What version of Word created the target document? What is the file type
(.doc, .docx...)? Is there any VBA used in the document?

What - exactly - is the wording in the error message?

Specific version info for Office might also be helpful.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

Hello again,

I found something peculiar
The path as highlighted when the cursor 'is on the cell (the light
yellow box) shows a path that doesn't exists.The path is:
file://localhost/users/lane/documents/LourtasBV/aanzetBV/administratie/G4S/facturen/2008/factuurG4S
2126.1412.08

However, the part '
file://localhost/users/lane/documents/LourtasBV/aanzetBV/administratie/
' exists but the following part ' G4S/facturen/2008/factuurG4S
2126.1412.08 ' is a part of another path.

Lane

 

[Leen]

I already answered 2 times, but it does not appear in the reader, so a
third time!

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon? Yes, no problem

How [step-by-step] are you creating the hyperlink?

Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?

Map is poor translation, but I meant a folder

Is there a network
involved? No
How lengthy is the path to the target file's location?

Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.

Do any of
the element names in the path use other than alphanumeric characters?

Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists

What version of Word created the target document? Office 2008 for Mac
What is the file type
(.doc, .docx...)? docx and xlsx
Is there any VBA used in the document? No

What - exactly - is the wording in the error message?

The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.

Version 12.1.3 Last update 12.1.5

 

[CyberTaz]

Hi Leen;

Apparently the replies have been posted but the Mactopia site has had
difficulty communicating with NNTP over the weekend so they haven't been
showing up in newsreaders.

Hyperlinks to local files should look something like:

file://localhost/Volumes/GigaTaz/Content%20from%20CubbyHole/Garbage%20Files/
BeneWin.txt

I have seen reports that a lengthy path can cause issues but not exactly of
the type you're reporting. If the retained path is incorrect, however, that
would certainly explain why the file can't be opened - it simply can't be
found. Since it is apparently not a problem with the file association or the
file itself I'd suggest recreating the hyperlink. See if the new one
behaves.

Regards |:>)
Bob Jones
[MVP] Office:Mac

I already answered 2 times, but it does not appear in the reader, so a
third time!

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon? Yes, no problem

How [step-by-step] are you creating the hyperlink?

Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?

Map is poor translation, but I meant a folder

Is there a network
involved? No
How lengthy is the path to the target file's location?

Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.

Do any of
the element names in the path use other than alphanumeric characters?

Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists

What version of Word created the target document? Office 2008 for Mac
What is the file type
(.doc, .docx...)? docx and xlsx
Is there any VBA used in the document? No

What - exactly - is the wording in the error message?

The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.

Version 12.1.3 Last update 12.1.5

Regards |:>)
Bob Jones
[MVP] Office:Mac

 

[Leen]

Op 2008-12-16 00:24:07 +0100, zei CyberTaz <[email protected]>:

Hello Bob,

Thanks so far for the effort you're making.

I found out that when I type the path manually there's no problem.
Inserting a hyperlink via the rightclick menu appears to be cause a
wrong non-existing path.
Typing a path manually is a lot of work (however some maybe made by
copy/paste) so Il ike to know why the wrong path is created by the
software. Is it a bug or something locally corrupted.

Lane

Hi Leen;

Apparently the replies have been posted but the Mactopia site has had
difficulty communicating with NNTP over the weekend so they haven't been
showing up in newsreaders.

Hyperlinks to local files should look something like:

file://localhost/Volumes/GigaTaz/Content%20from%20CubbyHole/Garbage%20Files/
BeneWin.txt

I have seen reports that a lengthy path can cause issues but not exactly of
the type you're reporting. If the retained path is incorrect, however, that
would certainly explain why the file can't be opened - it simply can't be
found. Since it is apparently not a problem with the file association or the
file itself I'd suggest recreating the hyperlink. See if the new one
behaves.

Regards |:>)
Bob Jones
[MVP] Office:Mac

I already answered 2 times, but it does not appear in the reader, so a
third time!

Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon? Yes, no problem

How [step-by-step] are you creating the hyperlink?

Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?

Map is poor translation, but I meant a folder

Is there a network
involved? No
How lengthy is the path to the target file's location?

Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.

Do any of
the element names in the path use other than alphanumeric characters?

Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists

What version of Word created the target document? Office 2008 for Mac
What is the file type
(.doc, .docx...)? docx and xlsx
Is there any VBA used in the document? No

What - exactly - is the wording in the error message?

The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.

Version 12.1.3 Last update 12.1.5

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/14/08 6:12 AM, in article
[email protected], "Leen"

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

 

[CyberTaz]

Interesting discovery... But I don't believe Excel "creates" the path. My
understanding is that it merely records the path reported to it by Finder,
so you may on to something.

Try starting your Mac from the OS X disk [or other bootable volume] & run
Disk Utility - Repair Disk (not Repair Disk Permissions) to see if it finds
& repairs any errors. If it does run it again until no errors are reported.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Op 2008-12-16 00:24:07 +0100, zei CyberTaz <[email protected]>:

Hello Bob,

Thanks so far for the effort you're making.

I found out that when I type the path manually there's no problem.
Inserting a hyperlink via the rightclick menu appears to be cause a
wrong non-existing path.
Typing a path manually is a lot of work (however some maybe made by
copy/paste) so Il ike to know why the wrong path is created by the
software. Is it a bug or something locally corrupted.

Lane

Hi Leen;

Apparently the replies have been posted but the Mactopia site has had
difficulty communicating with NNTP over the weekend so they haven't been
showing up in newsreaders.

Hyperlinks to local files should look something like:

file://localhost/Volumes/GigaTaz/Content%20from%20CubbyHole/Garbage%20Files/
BeneWin.txt

I have seen reports that a lengthy path can cause issues but not exactly of
the type you're reporting. If the retained path is incorrect, however, that
would certainly explain why the file can't be opened - it simply can't be
found. Since it is apparently not a problem with the file association or the
file itself I'd suggest recreating the hyperlink. See if the new one
behaves.

Regards |:>)
Bob Jones
[MVP] Office:Mac

I already answered 2 times, but it does not appear in the reader, so a
third time!

Op 2008-12-14 16:34:53 +0100, zei CyberTaz <[email protected]>:


Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon?
Yes, no problem

How [step-by-step] are you creating the hyperlink?
Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?
Map is poor translation, but I meant a folder
Is there a network
involved?
No
How lengthy is the path to the target file's location?
Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.
Do any of
the element names in the path use other than alphanumeric characters?
Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists


What version of Word created the target document?
Office 2008 for Mac
What is the file type
(.doc, .docx...)?
docx and xlsx
Is there any VBA used in the document?
No

What - exactly - is the wording in the error message?
The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.
Version 12.1.3 Last update 12.1.5

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/14/08 6:12 AM, in article
[email protected], "Leen"

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

 

[Leen]

Interesting discovery... But I don't believe Excel "creates" the path. My
understanding is that it merely records the path reported to it by Finder,
so you may on to something.

Try starting your Mac from the OS X disk [or other bootable volume] & run
Disk Utility - Repair Disk (not Repair Disk Permissions) to see if it finds
& repairs any errors. If it does run it again until no errors are reported.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Op 2008-12-16 00:24:07 +0100, zei CyberTaz <[email protected]>:

Hello Bob,

Thanks so far for the effort you're making.

I found out that when I type the path manually there's no problem.
Inserting a hyperlink via the rightclick menu appears to be cause a
wrong non-existing path.
Typing a path manually is a lot of work (however some maybe made by
copy/paste) so Il ike to know why the wrong path is created by the
software. Is it a bug or something locally corrupted.

Lane

Hi Leen;

Apparently the replies have been posted but the Mactopia site has had
difficulty communicating with NNTP over the weekend so they haven't been
showing up in newsreaders.

Hyperlinks to local files should look something like:

file://localhost/Volumes/GigaTaz/Content%20from%20CubbyHole/Garbage%20Files/
BeneWin.txt

I have seen reports that a lengthy path can cause issues but not exactly of
the type you're reporting. If the retained path is incorrect, however, that
would certainly explain why the file can't be opened - it simply can't be
found. Since it is apparently not a problem with the file association or the
file itself I'd suggest recreating the hyperlink. See if the new one
behaves.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/15/08 5:32 PM, in article
[email protected], "Leen"

I already answered 2 times, but it does not appear in the reader, so a
third time!

Op 2008-12-14 16:34:53 +0100, zei CyberTaz <[email protected]>:


Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon?
Yes, no problem

How [step-by-step] are you creating the hyperlink?
Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?
Map is poor translation, but I meant a folder
Is there a network
involved?
No
How lengthy is the path to the target file's location?
Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.
Do any of
the element names in the path use other than alphanumeric characters?
Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists


What version of Word created the target document?
Office 2008 for Mac
What is the file type
(.doc, .docx...)?
docx and xlsx
Is there any VBA used in the document?
No

What - exactly - is the wording in the error message?
The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.
Version 12.1.3 Last update 12.1.5

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/14/08 6:12 AM, in article
[email protected], "Leen"

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

Hello Bob,

I did what you suggested, but no change was made concerning the path issue.
It seems to me that excel indeed does not create the path. So the
finder is the alleged suspect.
Any ideas where and how to look further?

Lane

 

[CyberTaz]

Well, if that didn't do it I'm afraid I don't know what else to suggest :-(
I've played around with this a bit even though I don't really use hyperlinks
in Excel all that much. Any of the ones I've created seem to work as
expected no matter where or what file I link to. Since I can't recreate the
problem it's a bit difficult to troubleshoot.

If you compare the typed path to the one that gets inserted by the Insert
Hyperlink - Select method are you still seeing a difference? Since the path
apparently is being mishandled the only other idea I can offer is to get the
10.5.5 (or the now-available 10.5.6) Combo Update from the Apple Downloads
site. See if installing that makes a difference - the Combos are more
effective than what you get through Software Update.

Regards |:>)
Bob Jones
[MVP] Office:Mac

Interesting discovery... But I don't believe Excel "creates" the path. My
understanding is that it merely records the path reported to it by Finder,
so you may on to something.

Try starting your Mac from the OS X disk [or other bootable volume] & run
Disk Utility - Repair Disk (not Repair Disk Permissions) to see if it finds
& repairs any errors. If it does run it again until no errors are reported.

HTH |:>)
Bob Jones
[MVP] Office:Mac

Op 2008-12-16 00:24:07 +0100, zei CyberTaz <[email protected]>:

Hello Bob,

Thanks so far for the effort you're making.

I found out that when I type the path manually there's no problem.
Inserting a hyperlink via the rightclick menu appears to be cause a
wrong non-existing path.
Typing a path manually is a lot of work (however some maybe made by
copy/paste) so Il ike to know why the wrong path is created by the
software. Is it a bug or something locally corrupted.

Lane


Hi Leen;

Apparently the replies have been posted but the Mactopia site has had
difficulty communicating with NNTP over the weekend so they haven't been
showing up in newsreaders.

Hyperlinks to local files should look something like:

file://localhost/Volumes/GigaTaz/Content%20from%20CubbyHole/Garbage%20Files>>>>
/

BeneWin.txt

I have seen reports that a lengthy path can cause issues but not exactly of
the type you're reporting. If the retained path is incorrect, however, that
would certainly explain why the file can't be opened - it simply can't be
found. Since it is apparently not a problem with the file association or
the
file itself I'd suggest recreating the hyperlink. See if the new one
behaves.

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/15/08 5:32 PM, in article
[email protected], "Leen"

I already answered 2 times, but it does not appear in the reader, so a
third time!

Op 2008-12-14 16:34:53 +0100, zei CyberTaz <[email protected]>:


Hi Lane;

It's hard to tell from the limited information

Can you open the target file directly if you navigate to it in Finder &
double-click the icon?
Yes, no problem

How [step-by-step] are you creating the hyperlink?
Put the cursor on the particular cell, rightclick en click on
hyperlink. Then a 'wizard-ish' window opens and I just followed the
instructions.

What do you mean by "map" - folder, volume, drive...?
Map is poor translation, but I meant a folder
Is there a network
involved?
No
How lengthy is the path to the target file's location?
Here's a weird thing. The path in the wizard-ish window lacks the first
part of the actual path.
When putting the cursor on the cell a light yellow box shows up with
another 'impossible' path. As if two separate paths are connected.
Do any of
the element names in the path use other than alphanumeric characters?
Here's the path showed in the edit window:
G4S/Facturen/2008/Specificatie%20factuur%20G4S%202126.1412.08.xlsx
It is lacking the actual start of the path

The part which shows up in the light yellow box is:
file://localhost/users/lane/documents/lourtas
BV/aanzetBV/administratie/G4S/Facturen/2008/Specificatie factuur G4S
2126.1412.08.xlsx
This path is 'impossible' it doesnot exists


What version of Word created the target document?
Office 2008 for Mac
What is the file type
(.doc, .docx...)?
docx and xlsx
Is there any VBA used in the document?
No

What - exactly - is the wording in the error message?
The file asked for cannot be opened. (literally translated from Dutch)

Specific version info for Office might also be helpful.
Version 12.1.3 Last update 12.1.5

Regards |:>)
Bob Jones
[MVP] Office:Mac



On 12/14/08 6:12 AM, in article
[email protected], "Leen"

Hello,

I like to connect a invoice number (in an excel cell) to the
corresponding invoice (a Word file) with a hyperlink. When I do this I
get an error that file cannot be opened.
The files are in different maps.
What's wrong

I use Office 2008 for mac and Leopard 10.5.5

Lane

Hello Bob,

I did what you suggested, but no change was made concerning the path issue.
It seems to me that excel indeed does not create the path. So the
finder is the alleged suspect.
Any ideas where and how to look further?

Lane