How to Fix Excel Circular Reference Error When Workbook Won't Open
Question details
The user is unable to open an Excel workbook due to a circular reference warning accompanied by an unexpected Record Macro message.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Attempting to open a specific workbook containing complex formulas that has suddenly become inaccessible.
- Observed behavior
- The workbook fails to open, displaying a circular reference warning and a Record Macro message, blocking access to the file's data.
Always create a backup copy of your problematic workbook before attempting any troubleshooting steps or sharing the file for diagnosis.
Open Excel in Safe Mode and Trace Circular References
Bypassing add-ins and startup files allows the workbook to open safely so you can locate and fix the circular formula.
Safe mode prevents background calculations and add-ins from crashing Excel during startup, allowing you to manually access the Error Checking tools.
Press the Windows key + R on your keyboard to open the Run dialog box.
Type 'excel /safe' into the text box and press Enter to launch Microsoft Excel in Safe Mode.
Go to 'File' > 'Open', browse for your problematic workbook, and open it.
Navigate to the 'Formulas' tab, click on 'Error Checking', and select 'Circular References'. This will show you the exact cell causing the endless calculation loop.
Click on the identified cell, correct or delete the formula to break the loop, and save the workbook.

Disable Excel Add-ins
Sometimes, active add-ins or macro processes conflict with formula calculations, preventing the file from opening normally.
Share the Workbook for Diagnosis
If local troubleshooting fails, providing the workbook to a support professional or community expert can help identify complex formula errors.
Open and Fix Circular Reference Errors with WPS Spreadsheet
If Excel fails to open your workbook, try using WPS Spreadsheet. It provides excellent compatibility with Microsoft Office formats and features a robust Error Checking tool to quickly locate and resolve circular reference loops.
- 1. Install WPS Office: Download and install WPS Office, then launch WPS Spreadsheet.
- 2. Open the File: Click 'Menu' > 'Open' and select your problematic Excel workbook.
- 3. Access Error Checking: Navigate to the 'Formulas' tab and click on the 'Error Checking' drop-down.
- 4. Trace the Error: Select 'Circular References' from the menu to immediately highlight the conflicting cell.
- 5. Resolve the Loop: Edit the formula to remove the circular dependency, then save your repaired file.

Frequently Asked Questions
What is a circular reference in Excel?
A circular reference occurs when a formula directly or indirectly refers to its own cell, creating an endless calculation loop that can cause performance issues or prevent the workbook from functioning properly.
Why am I seeing a Record Macro message when opening my file?
This message can sometimes appear erroneously when Excel's calculation engine crashes or stalls due to a severe circular reference. It does not automatically mean your file contains a macro.
Will fixing the circular reference delete my data?
No, identifying and fixing a circular reference only requires you to correct the specific formula causing the loop. Your other data, values, and valid formulas will remain completely intact.
Can I find circular references if the workbook won't open at all?
If the file completely crashes Excel upon opening, you must first open Excel in Safe Mode or use a highly compatible alternative spreadsheet program like WPS Spreadsheet to bypass the initial calculation phase and access the diagnostic tools.




