excel - circural references

New Contributor

Bez naslova.jpg

5 Replies
I can not find where problem is, I have tries with formula checkin, but nothing


Do you mean this option


under "formula checkin" ?

@Sergei BaklanThank  you, I have find it in Circular references, this formula =MAX($B6:B$19)+1, what does it mean, can I delete it?


Which cell contains that formula?


Most probably you formula is in one of the cells with the range, e.g. in B19. Move it out of range, e.g. in B20.