Document Editing Problems

How to Restore the Missing Paste Link Option in Excel 365

Emma BrownEmma Brown Nov 4, 2026 870 views

Question details

The user is unable to find or use the Paste Link command when trying to link data between workbooks.

How to Restore the Missing Paste Link Option in Excel 365
Product
Microsoft Excel 365
Device & OS
not provided
Scenario
Copying data from one document and attempting to paste it as a dynamic link in another document or within a specific area like an Excel table.
Observed behavior
The Paste Link option disappears from the Paste Special right-click menu, especially when pasting inside a formatted table or in specific files.
Before you start

Before troubleshooting, ensure that you have actually copied a cell (Ctrl+C) rather than just clicking on it, and verify that both the source and destination files are saved on your local drive.

Solution 1Recommended

Paste Links Outside of Formatted Excel Tables

Excel tables do not natively support the Paste Link functionality directly inside their data body range. Pasting the link outside the table resolves this limitation.

One of the most common reasons the Paste Link option disappears is because the destination cell is located inside a formatted Excel Table (Insert > Table). Excel restricts array formulas and direct external workbook links within table columns to maintain data integrity.

1
Copy the source data

Navigate to your source document, select the cell containing the total or data you want to link, and press Ctrl+C to copy it.

2
Select a cell outside the table

Go to your destination workbook and click on a blank cell that is completely outside of any formatted Excel table boundaries.

3
Use Paste Special

Right-click the selected blank cell and look for the 'Paste Link' icon under the Paste Options, or click 'Paste Special' to find the Paste Link button at the bottom left of the dialog box.

Paste Links Outside of Formatted Excel Tables
Workaround for Tables: If you absolutely must have the linked value inside the table, paste the link into a cell outside the table first, then reference that new cell from within your table using a simple equals sign (=).
Seamlessly Link Data with WPS Office

Use WPS Spreadsheet to Paste Links Between Workbooks Easily

WPS Office offers a robust, highly compatible Spreadsheet application that handles cross-workbook data linking flawlessly. If you are struggling with Excel's missing Paste Link option, try WPS Spreadsheet for a smooth, restriction-free experience.

  1. 1. Open your workbooks in WPS Spreadsheet: Launch WPS Office and open both your source and destination spreadsheet files.
  2. 2. Copy the source data: Select the cell containing the sum or data you want to link, right-click it, and choose Copy.
  3. 3. Use Paste Special: Switch to your destination workbook, right-click the target cell, and hover over Paste Special.
  4. 4. Select Paste Link: Click on 'Paste Link' in the context menu to dynamically connect the data between your workbooks in seconds.
Fully compatible with Microsoft Excel (.xlsx, .xls) file formats.Reliable Paste Special and Link Data features that work consistently.Lightweight software with a familiar, easy-to-use interface.Free to use for everyday advanced spreadsheet tasks.
microsoft office alternative - wps office

Frequently Asked Questions

Why is Paste Link greyed out in Excel?

Paste Link is usually greyed out if you are trying to paste into a formatted Excel Table, if you haven't copied a valid range (e.g., copying a shape instead of a cell), or if the source document is a read-only file that hasn't been saved.

Can I use Paste Link between two different Excel files?

Yes, you can paste links between different workbooks. However, both files must be open in the same instance of Excel, and they should ideally be saved on your computer or a synced cloud folder to ensure the link updates properly.

Is there a keyboard shortcut for Paste Link?

Yes. After copying your source data, navigate to the destination cell and press the keys Alt, H, V, N sequentially to quickly apply a Paste Link without opening the full Paste Special menu.

Does Paste Link update automatically when source data changes?

Yes, once a link is successfully pasted, the destination cell will automatically update whenever the source data is modified. If the destination file is closed when the source is changed, Excel will prompt you to update links the next time you open the destination file.