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, 2022 in Others by Kithuzzz
• 38,010 points
832 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, 2022 by narikkadan
• 63,420 points

Related Questions In Others

0 votes
1 answer

How do I use the Indirect Function in Excel VBA to incorporate the equations in a VBA Macro Function

Try this: Sub Test() Dim str As String: str ...READ MORE

answered Jan 19, 2023 in Others by narikkadan
• 63,420 points
624 views
0 votes
1 answer

Excel VBA - Need to get a specific line from TextBox and send to an specific Cell

Moving your string into an array first ...READ MORE

answered Feb 2, 2023 in Others by narikkadan
• 63,420 points
466 views
0 votes
1 answer

Create a hyperlink to a sheet with same name as the value in the selected cell in Excel through VBA

Credit to Spectral Instance who found the ...READ MORE

answered Feb 6, 2023 in Others by narikkadan
• 63,420 points
551 views
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
730 views
0 votes
0 answers

MS Excel - SumProduct formula with Loop

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

Feb 18, 2022 in Others by Edureka
• 13,670 points
250 views
0 votes
1 answer

Converting HTML to Excel? [closed]

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

answered Feb 23, 2022 in Database by gaurav
• 23,260 points
348 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, 2022 in Database by Edureka
• 13,670 points
5,992 views
0 votes
0 answers

how to Convert HTML to Excel?

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

Jul 4, 2022 in HTML by Tejashwini
• 3,820 points
249 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, 2022 in Others by narikkadan
• 63,420 points
540 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, 2022 in Others by narikkadan
• 63,420 points
937 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