Excel - Circular Formulae

Copper Contributor

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.