Formula Errors

How to Fix Paste Link Unavailable and Circular Reference Errors in Excel

Aamir Naveed AkramAamir Naveed Akram Nov 13, 2026 869 views

Question details

User wants to know why Paste Link may be unavailable when copying between worksheets and how to identify indirect causes of circular-reference errors in an Excel workbook.

How to Fix Paste Link Unavailable and Circular Reference Errors in Excel
Product
WPS Office Spreadsheets and Microsoft Excel
Device & OS
not provided
Scenario
Copying data between worksheets and troubleshooting formula errors in an Excel workbook.
Observed behavior
Paste Link is unavailable in the destination, and circular-reference errors are triggered by indirect formula dependencies.
Before you start

Verify that the workbook is not protected or opened in a restricted editing mode, and confirm you copied a cell range rather than a chart, picture, or table object. Open Formulas > Error Checking > Circular References to see whether Excel has already detected a circular reference.

Solution 1Recommended

Make Paste Link Available When Copying Between Worksheets

Use this solution when the Paste Link option is grayed out or missing after copying cells in Excel or WPS Office.

Paste Link is normally available when you copy a cell range and paste into another worksheet or workbook. It may be disabled by protected workbooks, unsupported objects, restricted web versions, or table operations.

1
Copy a cell range

Select a range of cells, not a chart, picture, or table object, and press Ctrl+C.

2
Check destination compatibility

Switch to the destination worksheet or workbook, select a cell outside any Excel table, and right-click to open the paste options.

3
Disable protected or restricted mode

If Paste Link is missing, go to Review > Unprotect Sheet or Unprotect Workbook, and make sure the file is not open in a restricted editing view.

4
Use the desktop application

In WPS Office Spreadsheets or Excel desktop, right-click the destination cell and choose Paste Special > Paste Link.

Make Paste Link Available When Copying Between Worksheets
Paste Link should now appear: Paste Link should now be available when pasting a copied cell range into an editable worksheet.
WPS Office direct solution

Fix Paste Link and Circular Reference Issues in WPS Office Spreadsheets

WPS Office Spreadsheets can open, edit, and fix Excel workbooks with Paste Link and circular-reference problems. Use the same familiar paste special and error-checking tools to resolve the issue without changing your workflow.

  1. 1. Download and install WPS Office: Download WPS Office from the official website, run the installer, and open WPS Office Spreadsheets.
  2. 2. Open the Excel workbook: Click Menu > Open, select the .xlsx or .xls file, and confirm the workbook opens in edit mode.
  3. 3. Use Paste Link: Copy the source range, select the destination cell, right-click, and choose Paste Special > Paste Link.
  4. 4. Check circular references: Go to Formulas > Error Checking > Circular References to inspect and correct dependency chains.
  5. 5. Save the fixed workbook: Press Ctrl+S or use Menu > Save As to keep the Excel-compatible format.
Free spreadsheet application with Excel-compatible Paste Special and Paste Link supportBuilt-in formula error checking to trace circular references across sheetsOpens and saves .xlsx, .xls, and .xlsm files without reformattingFamiliar ribbon interface makes switching from Microsoft Excel simple
microsoft office alternative - wps office

Frequently Asked Questions

Why is Paste Link grayed out in Excel when I copy between worksheets?

Paste Link is grayed out when you copy an unsupported object such as a chart or picture, when the destination is inside a table, when the workbook or sheet is protected, or when you are using Excel for the web with limited paste features. Copy a normal cell range and use the desktop WPS Office Spreadsheets or Excel application.

How do I locate the exact cell causing a circular reference?

Click Formulas > Error Checking > Circular References. Excel or WPS Office lists the current circular-reference cells, and you can then inspect the formula bar and trace precedents and dependents.

Can named ranges or hidden sheets cause a circular reference?

Yes. A named range can point to a range that includes the formula cell, and hidden sheets can contain linked formulas that create an indirect circular reference. Check Formulas > Name Manager and unhide sheets to review those formulas.

Does enabling iterative calculation fix circular references?

Enabling iterative calculation stops the circular-reference warning and lets formulas recalculate repeatedly, but it only works if the workbook intentionally uses circular logic. Otherwise you should correct the formula dependency.

Can WPS Office open and fix Excel files with circular reference errors?

Yes. WPS Office Spreadsheets opens .xlsx, .xls, and .xlsm files and includes Formula error checking tools for circular references, along with Paste Special > Paste Link for linking cells between worksheets.