Forum Discussion
Column of Subtotals and Grand Total
Please check under
Formulas -> Error checking -> Circular reference
which cell contains a formula with a circular reference.
In my german Excel i've created a circular reference in cell G5 in order to show how to determine the cell with the circular reference.
At the bottom of the worksheet the cell containing the circular reference is displayed as well. "Zirkelbezug" in german Excel means circular reference.
Thank you for your response. I did as you suggested and the program did identify a particular cell as the problem. I checked that cell and all it had was one number, no formulas, pluses or anything else. I read somewhere that changing the formatting of a cell could cause this problem so I re-formatted the cell and thereafter got a message that the circular reference was resolved. I am in the middle of something else and cannot shut down the computer, so I will double check later to see if the problem has been fixed. Again thank you. OliverScheurich