microsoft excel cannot calculate a formula. there is a circular reference in an open workbook, but the references that cause it cannot be listed for you.

Question

I have tried everything I can think of. Can you please help with the following error message:

microsoft excel cannot calculate a formula. there is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the undo command

Answer 1

Hello,

I was having the same issue and went through all the steps and checked everything.  Then, I reread the article, and it said something about displaying circular references in the toolbar in the bottom left corner.  I looked and it displayed "Circular Reference E134."  I went to the cell and sure enough it was there!  I deleted the formula and then went through each tab (I had copied this sheet for months) and found the circular references and deleted them.  It was made most likely when I was clicking and dragging things.  I got so used to just clicking "Okay" that I stopped worrying about it...sometimes....hope this helps.

Answer 2

You're welcome!

Answer 3

This worked for me too. Thanks a lot!

Answer 4

I have tried everything I can think of. Can you please help with the following error message:

microsoft excel cannot calculate a formula. there is a circular reference in an open workbook, but the references that cause it cannot be listed for you. Try editing the last formula you entered or removing it with the undo command

Answer 5

Thank you! That solved my problem in a few minutes despite a completely unhelpful Excel error message. Really grateful!