Formula Errors

Fix an Excel Workbook That Won’t Open After a Circular Reference Error

Natalie TaylorNatalie Taylor Nov 14, 2026 868 views

Question details

The user needs to open an Excel workbook that does not appear after a circular reference warning.

Fix an Excel Workbook That Won’t Open After a Circular Reference Error
Product
Microsoft Excel
Device & OS
not provided
Scenario
Opening a workbook that triggers a circular reference warning before the worksheet becomes accessible.
Observed behavior
The workbook is not displayed after the user selects OK on the warning, including when Excel is started in Safe Mode.
Before you start

Locate the affected workbook and take a screenshot of the exact warning. Note your Excel version and whether any workbook window appears after you select OK.

Solution 1Recommended

Open the workbook from Excel in Safe Mode

Use this check to see whether the workbook opens without Excel add-ins and other startup features.

The user has already reported that Safe Mode did not resolve the issue. If you have confirmed the same result, continue to Open and Repair and collect the error details.

1
Start Safe Mode on Windows

Close Excel, press Windows+R, enter excel /safe, and select OK.

2
Open the workbook

In Excel, select File > Open, browse to the affected workbook, and open it.

3
Check the result

Select OK on the warning and check whether the workbook appears. If it does, select Formulas > Error Checking > Circular References to inspect the listed cells.

Open the workbook from Excel in Safe Mode
Safe Mode availability: The excel /safe command applies to Excel on Windows. The device and operating system for this issue were not provided.
Free Microsoft Office alternative

Review Excel Workbooks with WPS Spreadsheet

WPS Office is a free, lightweight alternative with a familiar spreadsheet interface. Its Excel format compatibility makes it easy to move existing workbooks into WPS for review, although it does not repair the underlying Microsoft Excel issue or guarantee that an affected workbook will open.

Open and review compatible Excel workbooks in WPS SpreadsheetCompatible with Microsoft Excel XLSX and XLS formatsUse a familiar interface to ease the move from Microsoft OfficeWork with a free, lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Where can I find a circular reference in Excel?

If the workbook opens, select Formulas > Error Checking > Circular References. Select a listed cell to inspect its formula.

What should I do if Safe Mode shows the same error?

Try File > Open > Browse > Open and Repair in Excel for Windows. If the workbook still does not appear, provide the error screenshot, Office version, and what happens after selecting OK to your support contact.

Does a circular reference always prevent a workbook from opening?

No. Excel can warn about a circular reference while still opening a workbook. If no workbook appears after the warning, the workbook or Excel startup environment may need further investigation.

Can WPS Spreadsheet fix this Excel error?

WPS Spreadsheet can open many XLSX and XLS files for review, but it does not fix the underlying Microsoft Excel problem and may not open every affected workbook.