+ Reply to Thread
Results 1 to 11 of 11

Hyperlink word file to excel file with specific sheet

  1. #1
    Registered User
    Join Date
    04-24-2004
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    70

    Hyperlink word file to excel file with specific sheet

    How I can hyperlink a excel file with a specific sheet.

    I am using ms-word xp version.

    In MS-word to MS-word document hyperlink it is possible by bookmark.

    thanks

    skaran

  2. #2
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,643

    Re: Hyperlink word file to excel file with specific sheet

    Here's how:
    First, save your Excel workbook.
    In Word, insert a hyperlink to the workbook, via Insert|Hyperlink.
    In Excel, on a different sheet that the one you want to hyperlink to, insert an '=' formula pointing to a cell on the target sheet. You should see something like =MySheet!J10.
    Select the inserted hyperlink and press Shift-F9. you should see something like:
    { HYPERLINK "C:\\Users\\Macropod\\Documents\\My Workbook.xls" }
    In Excel, copy the formula, except for the '=' and paste it into the hyperlink field in Word so that you end up with:
    { HYPERLINK "C:\\Users\\Macropod\\Documents\\My Workbook.xls" \l "MySheet!J10"}
    (Note the '\l' and double quotes.
    Close the Excel workbook without saving
    In Word, press F9 to update the hyperlink field.
    Click on the hyperlink and your Excel workbook shoould open at the desired location.
    Cheers,
    Paul Edstein
    [Fmr MS MVP - Word]

  3. #3
    Registered User
    Join Date
    08-08-2012
    Location
    New delhi
    MS-Off Ver
    Excel 2003
    Posts
    7

    Re: Hyperlink word file to excel file with specific sheet

    Thanks for sharing this .

  4. #4
    Registered User
    Join Date
    04-24-2004
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    70

    Re: Hyperlink word file to excel file with specific sheet

    Thanks Mr. Paul for supporting me.

    sorry for late reply.

    I have applied formula suggesteed by you but excel workbook opens in sheet whatever I saved last.

    Please suggest.

    Thanks
    Skaran

  5. #5
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,643

    Re: Hyperlink word file to excel file with specific sheet

    Hi Skaran,

    That suggests you have not implemented the process correctly. Try again.

  6. #6
    Registered User
    Join Date
    04-24-2004
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    70

    Re: Hyperlink word file to excel file with specific sheet

    Dear Mr. Paul,

    I am attaching two files

    1. Word file where I have applied your suggested formula.
    2. Excel - target file.

    In word file i have hyperlinked 3 sheets with different lines but always Sheet3 opens.

    Kindly check the formula.

    Thanks

    Skaran
    Attached Files Attached Files
    Last edited by kumawat_s; 08-09-2012 at 07:13 AM. Reason: forgot to attach files

  7. #7
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,643

    Re: Hyperlink word file to excel file with specific sheet

    You didn't pay close enough attention to the instructions. Where they say to use \l you have used \I.

  8. #8
    Registered User
    Join Date
    04-24-2004
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    70

    Re: Hyperlink word file to excel file with specific sheet

    Dear Mr. Paul,

    Sorry I did not find this character (|).

    If it near to backspace key, I have tried it but not worked and finallyi put \I.

    Could you send me the file after corrected formula.

    Thanks

    Skaran

  9. #9
    Forum Guru macropod's Avatar
    Join Date
    12-22-2011
    Location
    Canberra, Australia
    MS-Off Ver
    Word, Excel & Powerpoint 2003 & 2010
    Posts
    3,643

    Re: Hyperlink word file to excel file with specific sheet

    Hi Skaran,
    Sorry I did not find this character (|).
    How can you type my name if you cannot find the 'l' character? It is the lower-case letter L!!!!!! Please don't try to tell me you cannot find that!!!

  10. #10
    Registered User
    Join Date
    04-24-2004
    Location
    INDIA
    MS-Off Ver
    2013
    Posts
    70

    Re: Hyperlink word file to excel file with specific sheet

    Dear Mr. Paul,

    I am really very sorry I could not understand that is is lower case L. I assume that is some special character or I.

    Now It is working.

    Thank u very very much.

    Regards

    Skaran

  11. #11
    Forum Expert Cutter's Avatar
    Join Date
    05-24-2004
    Location
    Ontario,Canada
    MS-Off Ver
    Excel 2010
    Posts
    6,451

    Re: Hyperlink word file to excel file with specific sheet

    @ kumawat_s

    Based on your last post it seems that you are satisfied with the solution(s) you've received but you haven't marked your thread as SOLVED. I'll do that for you now but please keep in mind for your future threads that Rule #9 requires you to do that yourself. If your problem has not been solved you can use Thread Tools (located above your first post) and choose "Mark this thread as unsolved".
    Thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1