RE: Excel auditing
Hi Marilyn
In the recent versions of Excel, you will notice a green tag appears in the top left of your cells, if there is an error.
A SmartTag with a yellow exclaimation mark wil appear new to the formula. By click in on this you can track the error in the formula.
Alternatively you can click VIEW > TOOLBARS and then choose Formula Auditing. There are buttons that allow you to trace the error, track predecessors and dependant cells on that toolbar.
Regards
Richard