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
Смотрите видео Excel Hack: Fix Circular Reference Errors with the Circuit Breaker онлайн без регистрации, длительностью часов минут секунд в хорошем качестве. Это видео добавил пользователь Adventures in CRE 24 Декабрь 2015, не забудьте поделиться им ссылкой с друзьями и знакомыми, на нашем сайте его посмотрели 46,275 раз и оно понравилось 207 людям.