Creating a link from a word doc to a specific excel cell

Kirsten Affleck 25

Hi,

I'd like to create a link from a word document to a specific cell in a workbook sheet. I have tried \ work book address #gid=.'pagename -'!$A$160. which initially takes me to the correct cell but I get a pop up box saying "reference isn't valid" and when I put a different page name-cell ref it takes me back to the first cell referenced.

Is there any way I can do this easily and correctly please?

Thanks

Emi Zhang-MSFT 27,971 Reputation points Microsoft Vendor

2024-05-20T07:01:53.6066667+00:00

Hi,

Just checking in to see if the information was helpful. Please let us know if you would like further assistance.

If the response is helpful, please click "Accept Answer" and upvote it.

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.
Kirsten Affleck 25 Reputation points

2024-05-20T07:58:25.78+00:00

Hi,

That works for one link but when I try to add another link to an other cell it sets the original link to the new cell as well. Is there a way to do multiple link to multiple cells and keep them separate?

Also I'm not sure about doing this: Locate your Excel workbook and, in the Address box, type the defined name you created in Excel (e.g., "SalesTargetQ2").

As when I type only the defined name in the Address box I get an error message. If I use the address already in the address box (ie. my workbook address) the link takes me to the cell I've specified but I get the above problem.

Thanks
Gowtham CP 5,920 Reputation points

2024-05-20T10:19:48.9233333+00:00

Hi Kirsten Affleck ,

Thanks for your response.

To create multiple links to separate cells in an Excel workbook from a Word document, start by opening your Word document and positioning your cursor where you want to insert the first link. Right-click and choose Hyperlink or press Ctrl+K. In the "Link to" section, select "Existing File or Web Page" and locate your Excel workbook. In the Address box, enter the following formula, replacing the bracketed information with your details: =HYPERLINK("[C:\Users\Gowtham\ExcelFiles\SalesData.xlsx]SheetName!CellReference", "Display text for the link"). For example: =HYPERLINK("[C:\Users\Gowtham\ExcelFiles\SalesData.xlsx]Sheet1!A160", "Click here to view Q2 Sales Target"). Repeat these steps for each additional link, using the corresponding cell references and display text.

Hope it helps!
Kirsten Affleck 25 Reputation points

2024-05-20T12:30:34.33+00:00

Hi,

Thank you for that answer but unfortunately I'm not getting that to work.

Am I replacing the whole address with the formula?

I have the text already typed out and am right clicking to add a link to the excising text.

I am then locating my workbook then replacing the address with the formula (changed to my info) provided. I just get an error message ' can't open relevant file'.

Thanks
Kirsten Affleck 25 Reputation points

2024-05-21T13:23:23.9166667+00:00

Hi,

Thanks you for your answers so far.

Sorry but this is just not working at all now. :(

I have the text already written out so I'm just adding a link to that.

I right click, add link then find my work book... then what do I do?

replace the whole address with

=HYPERLINK(“[U:\myWORKBOOKetc.xlsx]sheetname'!$A$144”)

This is just returning an error message.

or do I add =HYPERLINK("[ and ]sheetname!A144") to the workbook address?

Thanks

Kirsten
Kirsten Affleck 25 Reputation points

2024-05-21T13:55:55.0833333+00:00

Hi,

I think I've managed it.

\address of WORKBOOK.xlsx#='sheetname'!$A$159

Seems to be working.

Accepted answer

Deleted

This answer has been deleted due to a violation of our Code of Conduct. The answer was manually reported or identified through automated detection before action was taken. Please refer to our Code of Conduct for more information.
1 deleted comment

Comments have been turned off. Learn more

2 additional answers

Dremich 5 Reputation points

2024-08-13T18:54:39.6566667+00:00
While in your Word doc,

Select text, and right-click.

Click Link.

Browse to and select your excel file. This will add the file path to the Address field.

After the end of the .xlsx file extension in the Address field, add #'Sheet1'!A1 replacing SHEET1 and A1 with the sheet name and cell name in your excel file.

For example, I want to link the text "see requirement" to sheet "Main" cell B23 in an excel file named REQUIREMENTS.xlsx. I right click "see requirement" and click Link. I make sure Existing file or Web Page is selected and navigate to my REQUIREMENTS.xlsx file. I click on the file, and REQUIREMENTS.xlsx is added to the Address field. I edit the Address field to be REQUIREMENTS.xslx#'Main'!B23. I click OK.

Might be late to the party here but hopefully this helps other people in the future.
Please sign in to rate this answer.

1 person found this answer helpful.
Dremich 5 Reputation points

2024-08-13T18:57:53.05+00:00

While in your Word doc,

Select your text and right click

Select Link

In Existing file or Web Page, navigate to and select your excel file

After the end of the .xlsx file extension in the Address field, add

#'SHEET1'!A1

replacing SHEET1 and A1 with the sheet name and cell name in your excel file.

Carl Potter 0 Reputation points

2024-11-19T19:28:21.37+00:00

Thank you Dremich! That worked wonderfully.
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.
Kirsten Affleck 25 Reputation points

2024-08-19T06:56:49.4933333+00:00

Thanks. I've managed to get it working with #cell address.
Please sign in to rate this answer.

0 comments No comments
Sign in to comment

Use comments to ask for clarification, additional information, or improvements to the question.

Share via

Creating a link from a word doc to a specific excel cell

2 additional answers

Your answer