How to Fix a Circular Reference from the Worksheet Name Formula in WPS Spreadsheets
Question details
The user needs to resolve a circular reference warning that appears after entering the worksheet name formula =MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255), which normally does not create the error by itself.
- Product
- WPS Spreadsheets / Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user wants to use a formula to return the current worksheet name without triggering a circular reference warning.
- Observed behavior
- WPS Spreadsheets or Excel reports a circular reference after the worksheet name formula is entered, usually because another formula refers back to the result cell or forms a calculation loop.
Save a copy of the workbook and confirm it has a saved file name and location, because the CELL("filename") part depends on the file path. Then open the Formulas tab in WPS Spreadsheets so Error Checking, Circular References, and Evaluate Formula are ready to use.
Locate and Break the Circular Reference with Error Checking
Use this first when the worksheet name formula itself is correct but the status bar or warning still reports a circular reference.
The worksheet name formula =MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255) returns a text value and does not loop by itself. The warning usually means another formula is reading the result cell and feeding back into the calculation.
In WPS Spreadsheets, click the Formulas tab, then click Error Checking and choose Circular References.
Click each cell shown in the Circular References list to jump to the cell that is part of the loop.
Check whether the flagged formula refers to the cell containing the worksheet name formula or to another cell that eventually forms a loop.
Change the formula or move the dependent calculation so it no longer writes back into the worksheet-name result cell.
Recheck Formulas > Error Checking > Circular References; when the list is empty, save the workbook.
Trace Dependents and Evaluate the Formula to Find the Loop
Use this if the circular reference is not obvious or if several formulas have recently been added or changed.
Enable Iterative Calculation Only for Intentional Circular References
Use this only if the circular design is intentional; otherwise remove the loop rather than simply allowing it.
Fix Circular References in WPS Spreadsheets with Built-in Error Checking
Open the workbook in WPS Spreadsheets and use the Formulas tab to identify the cells in the loop, trace dependents, evaluate formulas, and break the circular reference so your worksheet name formula works correctly.
- 1. Open the workbook and select the Formulas tab: Open the affected file in WPS Spreadsheets and click the Formulas tab on the ribbon.
- 2. Check Circular References: Click Error Checking, then choose Circular References to list each cell involved in the calculation loop.
- 3. Trace the dependency: Select the flagged cell or the worksheet-name result cell, and use Trace Dependents or Evaluate Formula to see how the formulas connect.
- 4. Break the loop: Edit the formula or link so the worksheet-name result is only used as a value and does not feed back into itself.
- 5. Save and verify: Confirm the circular reference list is empty, save the workbook, and let WPS Spreadsheets recalculate.
Frequently Asked Questions
Why does =MID(CELL("filename",A1),FIND("]",CELL("filename"))+1,255) return a circular reference?
The formula itself normally returns a text value and does not loop. The warning usually appears because another formula refers back to the cell containing this formula, forming a calculation loop.
Where do I find circular references in WPS Spreadsheets?
Click the Formulas tab, then go to Error Checking > Circular References. The list shows the cells involved; click an item to jump to that cell.
Should I enable iterative calculation to fix this error?
Only if the circular reference is intentional and the model requires iteration. For most worksheet name formula errors, remove or edit the dependent formula instead of enabling iterative calculation.
Can I still use the worksheet name formula after fixing the error?
Yes. The formula can remain in the cell as long as no other formula references it in a way that feeds back into the calculation loop.
Does WPS Spreadsheets support the CELL("filename") formula?
Yes. WPS Spreadsheets supports worksheet name formulas in Excel-compatible workbooks, and the built-in formula auditing tools can trace related dependencies.
