Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.word.docmanagement,microsoft.public.word.newusers
|
|||
|
|||
Links in Word Doc to specific worksheets in Excel Workbook?
Can this be done?
I am trying to resolve an issue in Excel by adding a Word document. I would like to create an index in Word that has links to specific worksheets in an Excel spreadsheet. The spreadsheet is complete and has 150 worksheets (tabs) but I can't seem to get the links in the Word document to go to the specific tabs - only to the Excel file. Any assistance is greatly appreciated. Thanks, Pam |
#2
Posted to microsoft.public.word.docmanagement,microsoft.public.word.newusers
|
|||
|
|||
Links in Word Doc to specific worksheets in Excel Workbook?
Pam - I am not sure if I understand you but generally, the best thing to do
in Word is: Insert, Object. Micorsoft Excel Worksheet. (If necessary, format the spreadhseet first so that it will look good in Word, e.g. get rid of cell gridlines etc.) Are you looking to insert all 150 worksheets into MS word? If you are trying to index the worksheets you may want to look into creating a concordance file. "Pam" wrote: Can this be done? I am trying to resolve an issue in Excel by adding a Word document. I would like to create an index in Word that has links to specific worksheets in an Excel spreadsheet. The spreadsheet is complete and has 150 worksheets (tabs) but I can't seem to get the links in the Word document to go to the specific tabs - only to the Excel file. Any assistance is greatly appreciated. Thanks, Pam |
#3
Posted to microsoft.public.word.newusers
|
|||
|
|||
Links in Word Doc to specific worksheets in Excel Workbook?
Pam Wrote: Can this be done? ....Word that has links to specific worksheets in an Excel spreadsheet. ... Hi Pam, have a look at the following link: http://www.shaunakelly.com/word/Exce...nks/index.html I think that might be usefull. Cheers, Arr -- Arr |
#4
Posted to microsoft.public.word.docmanagement,microsoft.public.word.newusers
|
|||
|
|||
Links in Word Doc to specific worksheets in Excel Workbook?
Hi ?B?UGFt?=,
I am trying to resolve an issue in Excel by adding a Word document. I would like to create an index in Word that has links to specific worksheets in an Excel spreadsheet. The spreadsheet is complete and has 150 worksheets (tabs) but I can't seem to get the links in the Word document to go to the specific tabs - only to the Excel file. Generally, hyperlinks to Office files in another application only open the file. They aren't able to jump to "targets" within a file. You'd probably need to use macro code in Word, rather than hyperlinks, to actually move to target areas in the Excel workbook. Cindy Meister INTER-Solutions, Switzerland http://homepage.swissonline.ch/cindymeister (last update Jun 17 2005) http://www.word.mvps.org This reply is posted in the Newsgroup; please post any follow question or reply in the newsgroup and not by e-mail :-) |
Reply |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Word 97 in Windows XP to maintain formatting | Microsoft Word Help | |||
Converting WordPerfect 12 files to Word 2003 | New Users | |||
Why dont MS just f**king re-write Word from scratch? Its dogsh*t | Microsoft Word Help | |||
How to put graphics on envelopes? | Microsoft Word Help | |||
Change paper size; Word changes to invalid margins | New Users |