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 ...
I know where it's coming from because it does indicate the circular reference cell at the bottom but even when I delete the so-called formula, I still get the error message as soon as I insert another row. I just wrote down the entries in that column, highlighted the whole column and clicked on clear contents from the menu when I right click. That did the trick, and now I just have to re-input the values that were deleted. Luckily there aren't many.
Correct, Excel autofills with the same formula next rows, that's default behaviour.
Not necessary to cut and enter again - select the column, Copy and after that Past as values on the same place