Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

I have just inherited a Workbook and I am trying to audit and document all the functions used.

The workbook has a good number of worksheets (+20) some of which are imported from CSV files while others are computed and re-used elsewhere in the workbook. In particular I have multiple ranges of data that have hundreds of values. I want to determine if any of these values are referenced/used elsewhere in a Excel workbook since we know that there is a huge amount of redundant data in the workbook.

Is there standard Excel functionality that I can use to achieve this? Or would I need to write a macro?

I could possibly, do a cell-by-cell analysis - but that could takes me days if not weeks.

share|improve this question
up vote 3 down vote accepted

See for single field dependency search and you can refer to for a macro approach.

It looks like it is not possible to use the excel provided functionality of finding dependent cells for multiple cells at once. So macro will be the feasible option for you.

share|improve this answer

When I need to do this, I use Ozgrid's Formula Manager then just use Ctrl-F on the report page to search for the item.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.