Quick check prior to DELETE sheet

[BallGazer]

Can anyone help?

I have inherited a complex workbook that I am tidying up. Is there an easy way to check an entire sheet to ensure there are no references or dependancies to other sheets within the workbook or externally? Formula Auditing seems to require a single cell reference rather than allowing a check of an entire sheet.

Thanks

BallGazer

[davesexcel]

Can anyone help?

I have inherited a complex workbook that I am tidying up. Is there an easy way to check an entire sheet to ensure there are no references or dependancies to other sheets within the workbook or externally? Formula Auditing seems to require a single cell reference rather than allowing a check of an entire sheet.

Thanks

BallGazer

Try this,
press F5(goto)
select special
formulas
if there are formulas they will be selected

[BallGazer]

Thanks Dave. Unfortunately the sheet has many formulas. I am only interested in references to other sheets/workbooks. Unfortunately I can't see the "Wood for the trees". Once again many thanks.

BallGazer

[BallGazer]

Dave

I take it all back. If you hit F5 GoTo Special and select Formulas >Text the external references are selected.

Many thanks

BallGazer