Software

Ask something
Discussion Locked

Hyperlink Excel to specific Word page

0 helpful
4 replies

by rbspecht

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

One of our users is trying to put set a hyperlink in an Excel 2000 spreadsheet that points to a specific page in a Word 2000 doc. We have tried setting a bookmark, and then setting the hyperlink to that file, and then the bookmark. We are getting an error message: Microsoft Excel could not open this file or could not parse this type of file.

What are we missing?

Thanking you in advance...

4 replies

by dklippert

From Jon Peltier's site:
http://www.peltiertech.com/Excel/Hyperlinks.html

Hyperlink to a Word Document

You can select any file to hyperlink to in the Insert Hyperlink dialog. To link to a particular bookmark in a Word document, don't click on the Bookmark button. Excel will reply with this warning: Microsoft Excel could not open this file or could not parse a file of this type. You can specify the bookmark by adding it yourself, appending an octothorpe (pound sign) plus the bookmark name to the path and file name.

C:\My Documents\MyDocument.doc#MyBookmark

To link to a particular page in a Word document, simply append a pound sign and the page number after the document path and file name:

C:\My Documents\MyDocument.doc#4

by pcrb

Thanks for your useful solution using the Hyperlink dialog.
Is there a way to create the hyuperlink using the =Hyperlink(...) formula ?
This would allow to include cell references that define the actual bookmarks, rather than having to go through the dialog for many instances.

This discussion is closed to new replies.