Hyperlinks in an embedded Excel worksheet

[JoAnn]

Hi,

I have an Excel spreadsheet embedded in a Word document.
The spreadsheet references instruction steps contained in
another part of the same Word document.

Is it possible to create an Excel hyperlink that can go to
the instruction steps contained in that same open WORD
document?

Thank you!
JoAnn

 

[JoAnn]

Hi,
Got this response in another user group and wanted to
share it with any one else interested in a solution to
this ... JoAnn

---------------------------------------------------
Hi JoAnn,

Yes you can.

Open you Excel workbook;
Select the text that you want to use as hyperlink;
Hit CTRL-K;
In the address field near the bottom, type the name of the
Word document and
the bookmark name like so:
[ Test.doc#MyBookmark ];
Save your Excel workbook;
Open the Word document where you want to embed the excel
data ("Test.doc" in
my example above);
Place the cursor where you want the data to go;
Go back to Excel;
Select the data;
Hit CTRL-C;
Go back to Word;
From the Edition Menu, select "Paste special...";
Select Paste with links;
Then, in the list on the right, select HTML format;
Click OK;
Save Word.

The Excel hyperlink should now refer to the bookmark in
the same Word
document.

--
Cheers!
_______________________________________
Jean-Guy Marcil - Word MVP
(e-mail address removed)
Word MVP site: http://www.word.mvps.org