Hyperlinks don't copy correctly from Word to Excel

Question

Hyperlinks don't copy correctly from Word to Excel

Joy Jolie 20

I have been successfully copying a table containing hyperlinks in Word to an Excel worksheet but suddenly the copy / paste stopped including the hyperlinks. I just get the text now.

Please advise. Thank you.

0 comments

Answer accepted by question author

0 additional answers

Your answer

Answer 1

Ivory 2,610 Independent Advisor

Hi Joy,

When pasting content from Word into Excel, try clicking the Paste Options button that appears after the paste operation and selecting Keep Source Formatting. Alternatively, go to Home > Paste > Paste Special and choose HTML Format, as this method is more likely to preserve hyperlinks.

To help determine where the hyperlinks are being lost, try copying a single hyperlinked cell from Word and pasting it into Excel. If the hyperlink is still not retained, the content may be getting converted to plain text during the paste process.

Another approach is to save the Word document as Web Page, Filtered (File > Save As) and then open the saved file in Excel. It is recommended to test this with a small sample first, as the results can vary depending on the document's formatting.

If the original URLs are available, you can also recreate the links in Excel by using the HYPERLINK function.

One important limitation to keep in mind is that Excel applies a hyperlink to an entire cell, not to specific portions of text within the cell. Therefore, if a Word table cell contains multiple hyperlinks, Excel may only be able to retain one hyperlink per cell after the paste operation.

If the issue continues after trying the suggestions above, please provide the following information:

Which versions of Word and Excel are you using (desktop, web, or mobile)?
Does the issue occur with all Word documents or only with a specific document?
Which paste method are you using in Excel (Ctrl+V, Paste Special, or another option)?
If you right-click a hyperlink in Word, is it a standard hyperlink or a field-generated hyperlink?

To ensure I provide the most accurate assistance, I would appreciate any additional information you can share regarding your current situation. If possible, please include screenshots, as they can be very helpful in the investigation.

Thank you for your patience and understanding. If you have any questions or need further assistance, please feel free to share them in the comments on this post.

If the answer is helpful, please click 'Yes' and kindly upvote it.

Note: Please follow the steps in the forum documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Ivory 2,610 Reputation points Independent Advisor

2026-11-01T17:26:42.49+00:00

Hi Joy,

Have you reviewed the provided answer? Please let me know if there are any updates.
Joy Jolie 20 Reputation points

2026-11-02T01:43:40.4533333+00:00

I've reviewed your answer and none of these options worked, specifically.

HOWEVER, I discovered something based on your comment above: "One important limitation to keep in mind is that Excel applies a hyperlink to an entire cell, not to specific portions of text within the cell. Therefore, if a Word table cell contains multiple hyperlinks, Excel may only be able to retain one hyperlink per cell after the paste operation."

While it wasn't obvious that there were two hyperlinks because there was no space between them, upon closer examination, I saw the trailing + symbol was a different hyperlink than the word Details. Here's what it looked like: For esthetic reasons, I had done a Find/Replace in the Word document prior to copying which was why it was working fine initially. But I didn't realize that I was correcting the issue by doing that. So, when I repeated the copy/paste I didn't bother to do the Find/Replace in Word BEFORE copying to Excel because I had no idea there were 2 hyperlinks and that made all the difference.

In summary, a Word table that has two hyperlinks in a cell will drop BOTH hyperlinks when copied into Excel. Which makes sense since Excel can't handle two hyperlinks in a single cell.

So, problem solved with your comment which put me on the right track by making me look closer at the hyperlinks. 👍

Thank you!
Joy

FYI: Veteran instructor here - MCT, 37 years teaching Microsoft Office computer skills in corporate settings, up to VBA programming level. STILL learning something new every day. Have a good one.
Ivory 2,610 Reputation points Independent Advisor

2026-11-02T21:20:20.22+00:00

Hi Joy,

That's great to hear, and thank you for sharing the root cause.

I'm glad the information helped point you in the right direction and that you were able to identify the issue. Thank you for coming back and posting the solution as it may help others who encounter the same behavior.