Summarize formula links between worksheets
 

I love using John Walkenbach's PUP tool, especially the ones related
to auditing.

I was wondering if anyone has taken the Formula Report one step
further. Currently, the report can lists all formulas on all
worksheets. This list can get overwhelming and I would like to see a
summary report that just lists each worksheet along with names of
other worksheets that are referenced within its formulas as well as a
formula count.

For example, to show that Sheet1 has 5 formulas referencing Sheet2, I
would like to see the following:

Sheet1 Sheet2 5

It would be nice to also have a list that shows the other direction
where I can see the names of other sheets that reference the active
sheet with a count.

I summary I am looking for a high-level listing of the formula
dependencies among my worksheets within a workbook.

Thanks,

Ray Lee

Summarize formula links between worksheets
 

http://j-walk.com/ss/pup/pup5/index.htm

Marilyn wrote:

The tool that you mention sounds like it will do EXACTLY what I need. Where can I get it?

"Ray Lee" wrote:

I love using John Walkenbach's PUP tool, especially the ones related
to auditing.

I was wondering if anyone has taken the Formula Report one step
further. Currently, the report can lists all formulas on all
worksheets. This list can get overwhelming and I would like to see a
summary report that just lists each worksheet along with names of
other worksheets that are referenced within its formulas as well as a
formula count.

For example, to show that Sheet1 has 5 formulas referencing Sheet2, I
would like to see the following:

Sheet1 Sheet2 5

It would be nice to also have a list that shows the other direction
where I can see the names of other sheets that reference the active
sheet with a count.

I summary I am looking for a high-level listing of the formula
dependencies among my worksheets within a workbook.

Thanks,

Ray Lee


--

Dave Peterson