Circular reference issue

HI All,

could you please help with this circular reference error. I was trying to solve it but without success :/

The error is occuring in cell S19 when trying to calculate the cell M18.

Many thanks
Lukas

Originally Posted by CK76

Well. It's one continuous cycle from Jan to Dec, when you check for previous month.

I.E. Jan refers to Dec, Feb to Jan .... Dec to Nov

So it loops back after 12 month. Does it not make sense to have another check (I.E. Year) or something that would stop 12 month cycle looping on itself?

Well it was working just fine till now. I don't know whats wrong with it

Did you just add/update Nov/Dec sheet? That likely completed the cycle and made circular reference.

Jan, shouldn't really reference back to Dec sheet, unless it's same year. If 2016 Dec data resides in another workbook, then it should refer to that, not current year's Dec (though you won't be able to use Indirect function on closed workbook).