Hyperlink to Excel

[Fred]

I can insert a hyperlink to open an Excel workbook but is there any way to
use the hyperlink to open the Excel workbook on a particular worksheet?

Thanks,
Fred

 

[Herb Tyson [MVP]]

Copy the Excel bits to the clipboard. Then, in Word, choose Edit - Paste
Special. Select Paste Link.

When I do that, I can go directly to the source of the paste (in Excel) by
right-clicking the object in Word, and choosing Linked Worksheet Object -
Edit link or Open link.

 

[Fred]

Thanks Herb, that works perfectly.

Copy the Excel bits to the clipboard. Then, in Word, choose Edit - Paste
Special. Select Paste Link.

When I do that, I can go directly to the source of the paste (in Excel) by
right-clicking the object in Word, and choosing Linked Worksheet Object -
Edit link or Open link.

--
Herb Tyson MS MVP
Author of the Word 2007 Bible
Blog: http://word2007bible.herbtyson.com
Web: http://www.herbtyson.com