Download the Workbook used in this video: http://www.adventuresincre.com/fix-circular-reference-errors-in-excel/
00:00 - Introduction
01:05 - Understanding Circular References
03:53 - Excel's Standard Functionality
04:53 - The Issue of Accidental Changes
06:06 - Introducing the Circuit Breaker
08:44 - Demonstrating the Circuit Breaker
A trick I learned from a friend and ex-colleague, Matt Robinson, the "Circuit Breaker" Excel hack fixes the incredibly frustrating permanent error issue that sometimes arises when you enter an erroneous value into a cell linked to a circular loop (iterative calculation).
This is a huge time saver, and a feature I now always include in models that rely on iterative calculations.
To learn about the author, visit his blog at: http://www.adventuresincre.com or his personal website at: http://www.spencerburton.org
