Forum Discussion
How to delete a circular reference?
I keep getting the error: "Careful, we found one or more circular references in your workbook that might cause your formulas to calcuate incorrectly," but I don't have any formulas in my spreadsheet ...
Claudia, sorry, i didn't catch this.
- if you have the reference, doesn't matter circular or not, you definetelly have formulas in your worksheet. Reference itself is the formula;
- you could add formulas eventually, not typing them manually, e.g. by clicking Totals within the icon which appears if you select at least couple of cells;
- blue circular reference line (after you click OK on alerting message) shows you two cells with circular reference, one of them is shall be with formula. Stay on cells and check formula bar what it shows.
- same formula shall be in all other cells of the same column - select the column and remove all
Above is just the direction where to find