Check workbook formulas

[VegasNath]

Please, Is there a way to check an entire workbook to find formulas that rely on one specific worksheet?

[HansV]

Press Ctrl+F to open the Find dialog (works in every version).
Enter the name of the sheet in the "Find what" box, followed by an asterisk and an exclamation mark, e.g. Sheet2*!
Click Options >>.
Select Workbook in the Within dropdown.
Make sure that Formulas is selected in the "Look in" dropdown, and that the "Match entire cell contents" check box is clear.
Click Find Next, or Find All.

[VegasNath]

Cheers Hans.

[HansV]

Keep in mind that if you have defined named ranges that refer to that specific worksheet, and if you have used these names in formulas, the method described above will not find those formulas.