If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Cyclic references in Excel, Excel for Android and Excel online

Thread starter J.Ty.
Start date Jan 1, 2020

Overview Discussion

J.Ty.

Well-known Member

Jan 1, 2020

J.Ty. submitted a new Excel article:

Cyclic references in Excel, Excel for Android and Excel online - How to detect cycles in all variants fo Excel

Cyclic references do show up. It is not difficult to inadvertedly create one.

Excel for desktop tells us about the fact immediately and demonstrates where the cycle is.
Excel for Android tells us about that, but does not locate the cycle.
Excel online does not tell us anything, but silently refuses to recalculate all cells on the cycle and ones that depend on them.
However, even Excel for desktop and for Android stop recalculating affected formulas and issuing warnings about subsequent...