| Error's tracker |  |
Excel has a tool called Trace Error, which, to be able to make it work, we have to activate the last cell with the error.
Another inconvenience of Excel is that when one tracks the error it also shows all the origin and dependence links of the cells involved - and many times we do not want for that to happen.
View Excel's tool in action:
Right, since we did not activate the proper cell, it simply did not track anything.
Quite the contrary, it shows a web of arrows, which say nothing.
Now let us use our tool:
All we have to do is click on the appropriate button of our toolbar, and it will automatically
detect the cells involved in the error, which are marked by a red line.
