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.