How to check if Excel tab is connected to a dependent tab in workbook?

Hi Dan,

A formula pointing to another sheet must have a "!" in the formula. If you use the Ctrl+F (Search) and search the sheet for this character it will stop if/when it is found. If the "!" is in a formula, you can't delete the sheet it is pointing to.

Excel also has other functions on the Functions Tab of Trace Precedents and Trace Dependents which will show if the formula goes off that sheet, which might help with an answer.

On the Home Tab in the Editing Group there is an icon for "Find & Select", where you can select only cells with formulas in them. Then if you click on the Icon for "Watch Window" it will show all those formulas in a list.
https://support.microsoft.com/en-us/...%20Add%20Watch.

Last you can show all formula on a sheet using the "Show Formulas" icon in the "Formulas Auditing" group.

If none of the above helps then a VBA solution might be appropriate for an answer.