Can't set hyperlink to Word bookmark

[wal]

Excel 2007 (& Word 2007)
Vista Enterprise SP1

This topic has been covered re older versions of Excel, with no
definitive answer.

I want to hyperlink a certain Excel cell to a specific point in a Word
document. I select the cell, hit Ctrl-k, and navigate to the file.
The path and file appear in the address problem.

I then press the Bookmark button. The following message appears:
"Microsoft Office Excel could not open this file or could not parse a
file of this type." [Why not? It's the same Office version?] The
Show Help button unhelpfully says that certain formats "such as XML"
don't support bookmarks so therefore you can't create a hyperlink to
such a file. Of course, Word does support bookmarks. (This problem
occurs with .doc and .docx files.)

I tried the following workaround: I created a hyperlink from a Word
file to a Word file and copy-pasted the Address (including bookmark)
in the Word hyperlink dialog to the Address box in the Excel hyperlink
dialog. This works. (An alternative would be to navigate in the
Excel hyperlink dialog to the desired file, then type "#", then type
the name of the bookmark.)

Anyway, any reason why the Bookmark button shouldn't work?

 

[Dave Peterson]

Maybe it's time to share what your hyperlink actually looked like.

I didn't test this in xl2007, but maybe you can try it and report back...

Saved from a previous post:

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")

Excel 2007 (& Word 2007)
Vista Enterprise SP1

This topic has been covered re older versions of Excel, with no
definitive answer.

I want to hyperlink a certain Excel cell to a specific point in a Word
document. I select the cell, hit Ctrl-k, and navigate to the file.
The path and file appear in the address problem.

I then press the Bookmark button. The following message appears:
"Microsoft Office Excel could not open this file or could not parse a
file of this type." [Why not? It's the same Office version?] The
Show Help button unhelpfully says that certain formats "such as XML"
don't support bookmarks so therefore you can't create a hyperlink to
such a file. Of course, Word does support bookmarks. (This problem
occurs with .doc and .docx files.)

I tried the following workaround: I created a hyperlink from a Word
file to a Word file and copy-pasted the Address (including bookmark)
in the Word hyperlink dialog to the Address box in the Excel hyperlink
dialog. This works. (An alternative would be to navigate in the
Excel hyperlink dialog to the desired file, then type "#", then type
the name of the bookmark.)

Anyway, any reason why the Bookmark button shouldn't work?

 

[wal]

My final hyperlink looks pretty much like yours, but that wasn't the
point of my question.

If, in the hyperlink dialog, you navigate to the file you want using
the "Look in" box, the path of that file automatically appears in the
Address box. So far, no problem.

My question was: Why doesn't the Bookmark button in the hyperlink box
work when the target file is a .doc file, which of course supports
bookmarks? Why do I get an error message?

I can get the ultimate result I want by typing "#" and the bookmark
manually after the filename in the Address box. But that makes it
that much more mysterious why the Bookmark button doesn't work.

Maybe it's time to share what your hyperlink actually looked like.

I didn't test this in xl2007, but maybe you can try it and report back...

Saved from a previous post:

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")

Excel 2007 (& Word 2007)
Vista Enterprise SP1

This topic has been covered re older versions of Excel, with no
definitive answer.

I want to hyperlink a certain Excel cell to a specific point in a Word
document.  I select the cell, hit Ctrl-k, and navigate to the file.
The path and file appear in the address problem.

I then press the Bookmark button.  The following message appears:
"Microsoft Office Excel could not open this file or could not parse a
file of this type."  [Why not?  It's the same Office version?]  The
Show Help button unhelpfully says that certain formats "such as XML"
don't support bookmarks so therefore you can't create a hyperlink to
such a file.  Of course, Word does support bookmarks.  (This problem
occurs with .doc and .docx files.)

I tried the following workaround: I created a hyperlink from a Word
file to a Word file and copy-pasted the Address (including bookmark)
in the Word hyperlink dialog to the Address box in the Excel hyperlink
dialog.  This works.  (An alternative would be to navigate in the
Excel hyperlink dialog to the desired file, then type "#", then type
the name of the bookmark.)

Anyway, any reason why the Bookmark button shouldn't work?

--

Dave Peterson- Hide quoted text -

- Show quoted text -

 

[Dave Peterson]

I don't know.

My final hyperlink looks pretty much like yours, but that wasn't the
point of my question.

If, in the hyperlink dialog, you navigate to the file you want using
the "Look in" box, the path of that file automatically appears in the
Address box. So far, no problem.

My question was: Why doesn't the Bookmark button in the hyperlink box
work when the target file is a .doc file, which of course supports
bookmarks? Why do I get an error message?

I can get the ultimate result I want by typing "#" and the bookmark
manually after the filename in the Address box. But that makes it
that much more mysterious why the Bookmark button doesn't work.

Maybe it's time to share what your hyperlink actually looked like.

I didn't test this in xl2007, but maybe you can try it and report back...

Saved from a previous post:

If I want a link in Excel that points at a specific location in an MSWord
document, I'd add a bookmark to that document and use one of these:

(Insert|hyperlink style)
C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01
Or
=hyperlink() style:
=hyperlink("C:\MY DOCUMENTS\WORD\MyDoc.DOC#bkmk01")

Excel 2007 (& Word 2007)
Vista Enterprise SP1

This topic has been covered re older versions of Excel, with no
definitive answer.

I want to hyperlink a certain Excel cell to a specific point in a Word
document. I select the cell, hit Ctrl-k, and navigate to the file.
The path and file appear in the address problem.

I then press the Bookmark button. The following message appears:
"Microsoft Office Excel could not open this file or could not parse a
file of this type." [Why not? It's the same Office version?] The
Show Help button unhelpfully says that certain formats "such as XML"
don't support bookmarks so therefore you can't create a hyperlink to
such a file. Of course, Word does support bookmarks. (This problem
occurs with .doc and .docx files.)

I tried the following workaround: I created a hyperlink from a Word
file to a Word file and copy-pasted the Address (including bookmark)
in the Word hyperlink dialog to the Address box in the Excel hyperlink
dialog. This works. (An alternative would be to navigate in the
Excel hyperlink dialog to the desired file, then type "#", then type
the name of the bookmark.)

Anyway, any reason why the Bookmark button shouldn't work?

--

Dave Peterson- Hide quoted text -

- Show quoted text -