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.

Hi Skaran,

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

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

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

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!!!