Arixcel Explorer is an Excel add-in for analyzing formulas in depth. It enables you to find out all the cells positions and values which are related with the formula in question. Even Though Excel 2010 has an built-in feature to seek out precedents and dependants of formula visually by pointing out the cells which are either dependent or precedent of the cell carrying formula. Arixcel Explorer takes this very functionality to the next level, letting you view all the cells, ranges and nested functions of the selected formula in the same hierarchy in which they are applied.
You will find it under Add-ins tab. To find out formula’s dependants/precedents, just select the formula cell and click Airxcel Explorer button. It will bring a dialog to explore the formula hierarchy, all the elements which are encapsulated in the formula can be explored. The bottom pane shows the complete formula, clicking the data range will lead you to the location where the respective cells are located.