Any formula scanner software available?

[Guest]

Greetings,

Does anyone know of any software that would scan thru Excel workbooks and
identify/gather formulas and/or show the relationship between formulas?

We have hundreds of worksheets, containing formulas, that we need to analyze
to determine the business rules that drive them. Was looking for a way that
might reduce the analysis time.

Many thanx,

-matt

 

[Dave O]

Can you give an example of what you'd like to see? Not sure I follow
when you say >identify/gather formulas< or >show the relationship
between formulas<. It's possible to write code that identify which
cells contains formulas, for instance, but where to go from there to
answer your requirements?

 

[Guest]

Hi,

In further searching, I came across a utility called "Explode" that, based
on screenshots on the website, would be along the lines of what I had in
mind. Unfortunately, the add-in errors out when attempting to use it.

Basically what I had in mind, was something that would graphically (or
otherwise) represent all the formulas in a workbook and show the dependencies
within the workbook as well as external dependencies. Something that would
generate a report would be outstanding.

Fyi, the web page for "Explode" can be found here:

http://www.xl-logic.com/pages/explode.html

While the formula auditing tools in Excel will show dependencies, it still
seems rather manual. Would be nice to have something scan the workbook and
display all formulas in one place.

Regards,

-matt

 

[Casey]

(e-mail address removed),
John Walkenbach has a utility package "Power Utility Pak" I think th
latest version in PUPv6 available by download for a free 30 day trial
It has several auditing features one of which is for auditing all th
formulas in a worksheet or workbook. I use it alot to final check m
stuff and it works perfectly. Note of caution if you generate a repor
on a large workbook with many worksheets with a lot of formulas it ca
sometimes take several minutes to finish.

here is the link. Look for the link to PUPv6

http://j-walk.com/ss/

HT

 

[Guest]

Many thanx, this should work nicely.

Regards,

-matt