Hi all,

I’ve been working on my RefTreeAnalyser again. What I’ve been up to this time is building tools which help with the analysis of dependencies which are mostly hidden from view:

• Charts (series formula)
• Pivot table (source data)
• Data Validation formulas
• Conditional Formatting formulas
• Form controls (linked cell, listfillrange)
• ActiveX controls (linked cell, listfillrange)
• Picture objects (linked cell)

A new dialog has been added that shows all sources of the objects in your file:

Moreover, when you analyse a particular cell for its dependencies, objects are taken into account too (well, to be perfectly honest, only if you purchase a license):

If you haven’t already done so, why don’t you head over to my website and download the tool. The demo is free and (almost!) fully functional.

Regards,

Jan Karel Pieterse
www.jkp-ads.com