Excel - Circular Formulae

%3CLINGO-SUB%20id%3D%22lingo-sub-2690325%22%20slang%3D%22en-US%22%3EExcel%20-%20Circular%20Formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2690325%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20a%20problem%20every%20time%20i%20open%20one%20particular%20Worksheet%20-%20message%20%22Circular%20Formulae%22%20and%20I%20have%20been%20unable%20to%20locate%20it%20to%20correct.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2690325%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2691160%22%20slang%3D%22en-US%22%3ERe%3A%20Excel%20-%20Circular%20Formulae%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2691160%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1138921%22%20target%3D%22_blank%22%3E%40garygardiner45%3C%2FA%3E%26nbsp%3BIn%20the%20bottom%20left-hand%20corner%20you%20should%20see%20a%20message%20like%20in%20the%20picture%20below.%20In%20indicates%20a%20reference%20to%20a%20cell%20that%20contains%20a%20circular%20reference.%20If%20there%20are%20more%20like%20theses%2C%20it%20will%20keep%20displaying%20new%20references%20until%20you%20have%20cleared%20them%20all.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Screenshot%202021-08-27%20at%2008.54.19.png%22%20style%3D%22width%3A%20249px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F306214iE4F9D4975AB2C668%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Screenshot%202021-08-27%20at%2008.54.19.png%22%20alt%3D%22Screenshot%202021-08-27%20at%2008.54.19.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

I have a problem every time i open one particular Worksheet - message "Circular Formulae" and I have been unable to locate it to correct.

4 Replies

@garygardiner45 In the bottom left-hand corner you should see a message like in the picture below. In indicates a reference to a cell that contains a circular reference. If there are more like theses, it will keep displaying new references until you have cleared them all.

 

Screenshot 2021-08-27 at 08.54.19.png

@garygardiner45 

Another way is to check from ribbon menu

image.png

if we speak about Windows, not sure about Mac.

@Sergei Baklan Same on Mac, though I've never looked there before

@Riny_van_Eekelen , nice to know, thank you.