J.Ty.

Cyclic references in Excel, Excel for Android and Excel online

J.Ty.

Well-known Member
Joined
Feb 4, 2012
Messages
1,102
Office Version
365, 2013, 2010
Platform
Windows, Web
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...
Read more about this Excel article...
 

Some videos you may like

Excel Facts

Ambidextrous Undo
Undo last command with Ctrl+Z or Alt+Backspace. If you use the Undo icon in the QAT, open the drop-down arrow to undo up to 100 steps.

Watch MrExcel Video

Forum statistics

Threads
1,095,933
Messages
5,447,390
Members
405,450
Latest member
JamesLH

This Week's Hot Topics

Top