Hi robertvarnam1,
Sorry that we don't have such feature. However, with our
Find and Replace in Multiple Workbooks feature, you can find-and-replace across multiple workbooks and worksheets. To do so, please follow the steps below:
1. Under
Kutools tab, click
Find >
Find and Replace in Multiple Workbooks.
2. Click the
Replace tab, type
[*] in the
Find what box, and leave the
Replace with box empty.
3. Select the workbooks and worksheets with references in formulas to other workbooks you want to remove.
4. Click
Replace All, you will see all the workbook names in the formulas are removed.
Note that you don't have other values that are enclosed with
[ ] that you don't want to remove. If you do, in the
Find what box, you will have to add the actual workbook name, for example,
[Book1].
For more details of the feature, please see this tutorial:
https://www.extendoffice.com/product/kutools-for-excel/excel-find-replace-in-multiple-sheets-files.html#a3
Amanda