Excel Hack: Fix Circular Reference Errors with the Circuit Breaker
Download the Workbook used in this video: http://www.adventuresincre.com/fix-ci...
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
Watch video Excel Hack: Fix Circular Reference Errors with the Circuit Breaker online without registration, duration hours minute second in high quality. This video was added by user Adventures in CRE 24 December 2015, don't forget to share it with your friends and acquaintances, it has been viewed on our site 46,275 once and liked it 207 people.