I have an Excel file that has many pivot tables. I reference these tables both in conventional formulas using cell references and using GetPivotData. Over time my file has changed many times and I have some pivot tables that are no longer used. I am attempting to determine if each pivot table has dependents by using the "find/replace" menu option (like this ... Find What: "Sheet1$AA"). But I am wondering if there is a better way to do this. Anyone know of a better way to determine if a pivot table has dependents or is referenced in other cells in the workbook?

Thanks