How do I create a hyperlink from Word to Excel specific cell without macros vba

0 votes

In reference to Creating hyperlinks from Excel FlowChart to MS Word Heading

I need to know the proper syntax for creating a hyperlink from a Word document to a particular cell in an Excel workbook.

For instance: Let's say I want to add a hyperlink to the Excel file DataStuff, but to Cell ZX200, while I'm in the word document "Explaining." Without VBA/MACROS, how would I go about doing this manually?

I already know that to hyperlink to DataStuff I would type

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

Then hit ENTER. (It then becomes an underlined hyperlink. Clicking on it opens DataStuff)

I would like to add that it should proceed to cell ZX200 rather than just opening DataStuff at cell A1, though. The following is ineffective. Could someone just improve the syntax?

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

I don't get how the Excel to Word question was answered in about 10 minutes, and my Word to Excel question accumulated crickets and tumbleweed. No MS Word experts??

I've figured it out after browsing many useless, and useful documents. The correct syntax is:

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

That should be typed into your word document and will go to cell ZX200 in worksheet Sheet1 in Excel. Using the information fro the hyperlink I had in my question, you now have a wonderful BIJECTION between Word and Excel hyperlinking. So that when you send people somewhere, you can also send them back!

Oct 15 in Others by Kithuzzz
• 20,660 points
38 views

1 answer to this question.

0 votes

All you have to do is copy the Excel cell you wish to reference, then in Word, select "Paste Special" > "Link & Merge Formatting" in the location where you want the link to appear.

A Field is then added to Word, which won't appear as a hyperlink and will instead be greyed out when the pointer is over the text. By performing the following actions, this field can be linked to the particular cell in the Excel file:

  1. Right-click on the field
  2. Then select Linked Worksheet Object > Open Link

Your Excel file should open up to the desired cell.

answered Oct 15 by narikkadan
• 37,660 points

Related Questions In Others

0 votes
1 answer

How do I start studying Node.JS to create a restful API?

Node.js is an open source server environment ...READ MORE

answered Jun 11, 2019 in Others by ArchanaNagur
• 2,360 points
481 views
0 votes
1 answer
0 votes
1 answer
0 votes
1 answer

How to stick an embedded document in a specific cell of an excel

Solution Select the documents (you can use the ...READ MORE

answered Oct 18 in Others by narikkadan
• 37,660 points
32 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

1 I have 4 arrays of data where ...READ MORE

Feb 18 in Others by Edureka
• 13,640 points
78 views
0 votes
1 answer

Converting HTML to Excel? [closed]

Upload html-file(s) Select files from Computer, Google ...READ MORE

answered Feb 23 in Database by gaurav
• 22,040 points
61 views
0 votes
1 answer

Excel 2010 CTRL+SHIFT+L. Not working

The Macro-containing workbook was always open in ...READ MORE

answered Apr 4 in Database by Edureka
• 13,640 points
1,147 views
0 votes
0 answers

how to Convert HTML to Excel?

I need to convert the HTML template ...READ MORE

Jul 4 in HTML by Tejashwini
• 2,860 points
58 views
0 votes
1 answer

Trying to create an enclosing bookmark after pasting a picture from Excel into Word using VBA

Try this: Sub IMPORT_TO_WORD() Dim ws1 As Worksheet, ws2 ...READ MORE

answered Oct 30 in Others by narikkadan
• 37,660 points
35 views
0 votes
1 answer

How do delete an specific page in a word document using Excel VBA?

Check the code below. I eliminated the ...READ MORE

answered Nov 21 in Others by narikkadan
• 37,660 points
19 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP