Analyze Calculation Errors
How many error values your model contains?
Brief look into several worksheets doesn't give you an answer. What about if:
- Your workbook has thousands of formulas
- There are hidden sheets in the book, which are not visible
- Don't format to check list of Names, which also could have thousand values.
- and more ...
Display Errors command gives you an answer in a second!
All calculation errors are in this list. There are no other error values in the model!
Need to know which function produce this error?
Just double click on the item you need, and you'll be pointed to the source of the error.