SOLVED

Circular reference

%3CLINGO-SUB%20id%3D%22lingo-sub-2718744%22%20slang%3D%22en-US%22%3ECircular%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2718744%22%20slang%3D%22en-US%22%3EHow%20do%20I%20remove%20a%20circular%20reference%20in%20excel%3F%20I%E2%80%99ve%20tried%20going%20to%20formulas%20%2F%20Europe%20checking%20%2F%20and%20then%20then%20circular%20reference%20but%20the%20circular%20reference%20isn%E2%80%99t%20clickable%20for%20some%20reason.%20I%20keep%20getting%20the%20message%20pop%20up%20in%20my%20spreadsheet%20every%20time%20I%20enter%20a%20number%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2718744%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719352%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719352%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146298%22%20target%3D%22_blank%22%3E%40Jules1245%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EIf%20you%20look%20at%20the%20status%20bar%20at%20the%20bottom%20of%20the%20Excel%20window%2C%20do%20you%20see%20an%20indication%20of%20which%20cell%20causes%20the%20circular%20reference%3F%20If%20your%20workbook%20has%20multiple%20sheets%2C%20you'll%20have%20to%20activate%20each%20of%20them%20in%20turn.%3C%2FP%3E%0A%3CP%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22S0730.png%22%20style%3D%22width%3A%20248px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308120iA519C0A66923FB8D%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22S0730.png%22%20alt%3D%22S0730.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2719438%22%20slang%3D%22en-US%22%3ERe%3A%20Circular%20reference%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2719438%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1146298%22%20target%3D%22_blank%22%3E%40Jules1245%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EStrange%20it%20doesn't%20forward%20you%20on%20the%20cell%20with%20circular%20reference%20if%20to%20click%20on%20shown%20reference.%20Do%20you%20use%20this%20menu%3F%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20346px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F308124i59CAC5C16D4E9865%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor
How do I remove a circular reference in excel? I’ve tried going to formulas / Europe checking / and then then circular reference but the circular reference isn’t clickable for some reason. I keep getting the message pop up in my spreadsheet every time I enter a number
3 Replies
best response confirmed by allyreckerman (Microsoft)
Solution

@Jules1245 

If you look at the status bar at the bottom of the Excel window, do you see an indication of which cell causes the circular reference? If your workbook has multiple sheets, you'll have to activate each of them in turn.

 

S0730.png

@Jules1245 

Strange it doesn't forward you on the cell with circular reference if to click on shown reference. Do you use this menu?

image.png

Thank you! I finally saw that at the bottom as was able to find it!