How to create a hyperlink from a specific Word cell in Excel without macros / vba?

Question

Regarding Creating Hyperlinks from Excel FlowChart to MS Word Headers

I would like to know the correct syntax for hyperlinking to a specific cell in an Excel Work <workbook from a Word document.

For example: Say that I am in the text document "Explanation", and I want to insert a hyperlink in the Excel DataStuff file, but in Cell ZX200 . How can I do this manually, without VBA / MACROS?

I already know that for a hyperlink to a DataStuff I would type

File:///c:\users\Win7User\desktop\DataStuff.xlsx 

Then press ENTER. (Then it becomes an underlined hyperlink. Clicking on it opens a DataStuff)

However, I want to add the fact that it should go to cell ZX200, and not just open the DataStuff in cell A1. The following does not work. Can someone fix the syntax for me?

  Does not work: File:///[c:\users\Win7User\desktop\DataStuff.xlsx]Sheet1!ZX200 

---

I don’t understand how the answer to the Excel question in Word was received after about 10 minutes, and there were problems with crickets and delta in my Word to Excel. No MS Word experts?

I realized this after looking at many useless and one useful document. The correct syntax is:

  File:///c:\users\Win7User\desktop\DataStuff.xlsx#Sheet1!ZX200 

This should be printed in your text document and go to cell ZX200 in sheet Sheet1 of the Excel sheet. Using the hyperlink information that I had in my question, you now have a wonderful relationship between the Word and Excel hyperlink. So when you send people somewhere, you can also send them back!

http://www.shaunakelly.com/word/word-and-excel/excelhyperlinks.html

Answer 1

All you have to do is copy the cell in Excel that you want to link, and then in Word, at the place where you want the link to be, you will be Paste Special> Link and Formatting Merge

What happens is this field is inserted into Word (it will not look like a hyperlink, but will be grayed out if the cursor is placed in the text). This field can refer to a specific cell in the Excel file by following these steps:

• Right click on the field
• Then select Linked Worksheet Object > Open Link

Your Excel file should open to the desired cell.

Answer 2

I read these links and could have a different solution for a non-VS guru (e.g. me).

• Open an Excel workbook, go to formula -> Define NAME
• Create a "NAME" for each of the cells or groups of cells that you want to link. For example, I hyperlinked the question # in a Word document with an Excel document, which is used to import questions into our learning management system. Example NAME = Question_22 and refers to cell range = WBT16DS058! $ A $ 90 (= worksheet! Cellrange)

• Save and close the Excel workbook.

• Open a Word document and create text (question 022), select and paste the hyperlink.

• Browse and select an Excel document, add the end of the address to include #NAME. (i.e. - R312Test.xlsx # Question_22).
• Select a new link and your Excel document will open the correct question.

We inserted and deleted rows to make sure that the Excel NAME link matches the range of cells when choosing a hyperlink in Word.

Answer 3

The shortest explanation that I found out of various ways to do this (Office 2013) is really in the dialog box that appears when you open the file containing the links (after the extension of the Show Help button). The first two options apply to Excel:

The text of which lists options for creating links:

• Using the Paste Special command (on the Home tab, in the Clipboard group, click the arrow below Paste , and then click Paste Special ), and then click the Paste Link link .
• Using the Object command (on the Insert tab) in the Text group, select Object and then click Object ), and then click the Link to file button on the Create from file tab.
• Using the Link to File or Insert command and the link in the Insert Picture dialog box (in the Insert strong> section in the Illustrations group, click Image , and then click the arrow next to Insert ).

You can also easily manage multiple links in one place, as described in this article , which also visually illustrates the above procedures. Options include automatic / manual updates and blocking of current values ​​when updating.

Answer 4

I believe that the alleged question refers to the permalink to a specific Excel value, even if the value moves to a new cell. With Paste Link, if a row or column is inserted above or below the desired value, the reference cell no longer contains the desired value. Link integrity is compromised, introducing invalid data or empty data into Word Word. Ideally, the user can use the Named Range in Excel and a hyperlink to the named range. The named range will still follow the value if the item is moved in Excel.