To check and confirm if external links are causing the error, follow these steps,
When the Excel file contains external links with error, MS Excel may display such error messages. In case the error is not fixed, you can back up the faulty sheet content and remove it from the workbook to save the Excel file. This method makes the entire process of troubleshooting Excel formula reference error quite easy and convenient.
This will help you find the faulty sheet from the workbook that you can review. To find the faulty sheet and fix the problem, you can copy each sheet content in a new Excel file and then try to save the Excel file. The problem may also occur due to an issue with one of the sheets in the workbook. If the error message persists, proceed to the next method. In such a case, you can try saving the Excel file again. The error check is completed for the entire sheet. If no issue is found, it displays the following message, This runs a scan on the sheet and displays the issues, if any.Go to Formulas and click on the ‘Error Checking’ button.To run Error Checking in the Excel sheet, follow these steps, In such cases, you can use the Error Checking option that runs a scan and checks for a problem with formulas used in the worksheet. If the problem has occurred in a large Excel workbook with multiple sheets, it’s quite hard to pinpoint the problem cell. Methods to Resolve ‘Excel Found a Problem with One or More Formula References in this Worksheet’ Errorįollowing are a few methods that you can follow to fix Excel file that can’t be saved due to problems with one or more formula references in the worksheet.