Circular Reference in excel

%3CLINGO-SUB%20id%3D%22lingo-sub-1262480%22%20slang%3D%22en-US%22%3ECircular%20Reference%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262480%22%20slang%3D%22en-US%22%3E%3CP%3EI%20am%20getting%20the%20%3CSTRONG%3E%22Excel%20cannot%20calculate%20a%20formula%2C%20there%20is%20a%20circular%20reference%20in%20an%20open%20workbook%2C%20but%20the%20references%20that%20cause%20it%20cannot%20be%20listed%20for%20you.%26nbsp%3B%20%26nbsp%3BTry%20editing%20the%20last%20formula%20you%20entered%20or%20removing%20it%20with%20the%20Undo%20command.%22%26nbsp%3B%3C%2FSTRONG%3E%20error%20message.%26nbsp%3B%20%26nbsp%3BMy%20workbook%20is%2030%20pages%20long%20and%20each%20page%20contains%20hundreds%20of%20formulas.%26nbsp%3B%20%26nbsp%3B%20I%20didn't%20get%20this%20error%20message%20until%20after%20I%20had%20made%20multiple%20changes.%26nbsp%3B%20%26nbsp%3B%20%26nbsp%3BIs%20there%20any%20way%20to%20identify%20it%2C%20other%20that%20checking%20each%20formula%2C%20which%20would%20take%20days%20or%20weeks.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1262480%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1262637%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20Reference%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1262637%22%20slang%3D%22en-US%22%3EThe%20address%20of%20the%20circular%20reference%20is%20indicated%20at%20the%20status%20bar%20at%20the%20bottom%20of%20your%20screen.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281228%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20Reference%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281228%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F280482%22%20target%3D%22_blank%22%3E%40Twifoo%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENo%2C%20the%20excel%20message%20said%20it%20couldn't%20identify%20the%20source%20of%20the%20error%2C%20so%20no%20reference%20was%20given.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1281244%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20Reference%20in%20excel%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1281244%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EYou%20can%20check%20the%20video%20links%20below%20to%20resolve%20the%20circular%20reference%20issue%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3Dj0nRTcoKrE0%26amp%3Bt%3D229s%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3Dj0nRTcoKrE0%26amp%3Bt%3D229s%3C%2FA%3E%3CBR%20%2F%3E%3CBR%20%2F%3E%3CA%20href%3D%22https%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DTpTZnI53IF8%22%20target%3D%22_blank%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3Ehttps%3A%2F%2Fm.youtube.com%2Fwatch%3Fv%3DTpTZnI53IF8%3C%2FA%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I am getting the "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."  error message.   My workbook is 30 pages long and each page contains hundreds of formulas.    I didn't get this error message until after I had made multiple changes.     Is there any way to identify it, other that checking each formula, which would take days or weeks.

3 Replies
The address of the circular reference is indicated at the status bar at the bottom of your screen.

@Twifoo 

 

No, the excel message said it couldn't identify the source of the error, so no reference was given.

Hello,

You can check the video links below to resolve the circular reference issue

https://m.youtube.com/watch?v=j0nRTcoKrE0&t=229s

https://m.youtube.com/watch?v=TpTZnI53IF8