How to Fix Paste Link Unavailable and Circular Reference Errors in Excel
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.

- 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.
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.
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.
Select a range of cells, not a chart, picture, or table object, and press Ctrl+C.
Switch to the destination worksheet or workbook, select a cell outside any Excel table, and right-click to open the paste options.
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.
In WPS Office Spreadsheets or Excel desktop, right-click the destination cell and choose Paste Special > Paste Link.

Trace Hidden and Indirect Circular References
Use this solution when the workbook shows a circular-reference error but the visible formulas look correct.
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. Download and install WPS Office: Download WPS Office from the official website, run the installer, and open WPS Office Spreadsheets.
- 2. Open the Excel workbook: Click Menu > Open, select the .xlsx or .xls file, and confirm the workbook opens in edit mode.
- 3. Use Paste Link: Copy the source range, select the destination cell, right-click, and choose Paste Special > Paste Link.
- 4. Check circular references: Go to Formulas > Error Checking > Circular References to inspect and correct dependency chains.
- 5. Save the fixed workbook: Press Ctrl+S or use Menu > Save As to keep the Excel-compatible format.

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.




