Posted 18 November 2017, 6:46 am EST
I think I came across a weird bug. See example in https://jsfiddle.net/xspg07f7/17/
In one sheet, [A2] = [A1]+1. In another sheet, [A1]=Sheet1!A2 and [A2]=Sheet1!A1.
It’s very important to use the same cells in both sheets, A1 and A2 in my example. And it’s important that A2 will point to A1 of the first sheet and A1 to A2 in the first sheet (not A1 to A1).
Bottom line, when you change [A1] in the first sheet, [A2] doesn’t change and doesn’t get re-calculated even though it’s equal to [A1]+1