If you want to find and fix Circular References in Microsoft Excel, then this guide will help you get the job done with ease.

When you see the #VALUE error, it means that there is something wrong with the way the formula is typed, or there is something wrong with the cells you are referencing.

How to Remove Circular References in Excel. In a Microsoft Excel 2010 spreadsheet, you may have formulas sitting in one cell that require the information within another cell in order to calculate.