This browser is no longer supported.
Upgrade to Microsoft Edge to take advantage of the latest features, security updates, and technical support.
![](data:image/svg+xml, %3Csvg xmlns='http://www.w3.org/2000/svg' height='64' class='font-weight-bold' style='font: 600 30.11764705882353px "SegoeUI", Arial' width='64'%3E%3Ccircle fill='hsl(128, 8%, 22%)' cx='32' cy='32' r='32' /%3E%3Ctext x='50%25' y='55%25' dominant-baseline='middle' text-anchor='middle' fill='%23FFF' %3EA%3C/text%3E%3C/svg%3E)
I consistently use the "Link and Keep Source Formatting" paste option to paste ranges from Excel to Word and be able to update the data dynamically from Word. However, that paste option now no longer shows up when I try to paste a range of Excel cells.
Is this option no longer available? How can I get it to show up again?
Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.
In Word, you will find that command on the Paste Options button when pasting an Excel range. See the screen shot below.
That option is usually there, but it is no longer showing up. Now when I try to paste an Excel range, these are the only options appearing:
Are you seeing this issue when pasting from a specific Excel file?
Are you able to paste linked data via the Paste Special dialog box in Word?
No, the issue was not occurring with a specific Excel file, and I was not able to paste the linked data via the Paste Special dialog box.
I'm not sure why, but it looks like the Paste as Link option has reappeared in my paste options. However, the "Update Link" option now no longer shows up when I right click on the pasted data:
Is there another way to update the data?
If you click the Links option, Word displays the Links dialog box which lists all OLE objects in the document with a lot of settings. You can update from there (as well as specify other settings).