The Auditing Toolbar is one if Excel's best kept secrets. It allows you to visualise the cells used in any formulae. In particular it allows you to view what cells are being used by a particular formulae, what other cells are relying on the cell you have specified, follow links to other spreadsheets and more recent versions of Excel include some error checking capabilities.
Excellent. Tks heap
batigoltuan 2 years ago