Link to specific Excel worksheet

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello

I want to insert a specific worksheet out of an excel workbook into a word doc. This worksheet will be hidden in the excel workbook
I defined a name for the range on this sheet I want to display in word and tried the # option but this doesn't work
When I create the link to the file, it links to the first visible worksheet

How do I solve this ?
 
Select the worksheet in Excel, then copy it to the clipboard and then in
Word use Paste Special and click on the Paste Link button.

--
Please post any further questions or followup to the newsgroups for the
benefit of others who may be interested. Unsolicited questions forwarded
directly to me will only be answered on a paid consulting basis.

Hope this helps
Doug Robbins - Word MVP
 
Back
Top