Jump to content

Auditing errors


Recommended Posts

Auditing errors

No one likes to see an error message show up in his or her Excel sheets. The presence of an error message means that somehow, somewhere, a typographical error has been made in a formula, or a piece of information is either missing or incorrect.

If you composed the formula that's returning an error, you may not have much trouble determining where the problem is. However, if you're working on someone else's worksheet, try using the Auditing tools to discover what's causing the error.

Just click on the cell that contains the error message and then go to Tools | Auditing | Trace Error. When you do, Excel will draw an arrow to the cell that contains the error, from every cell that the formula references. Then you can tell at a glance which cells you need to audit to confirm that they contain the right kind of information.

After you've audited the problem, remove the arrows by going to Tools | Auditing | Remove All Arrows.

Link to comment
Share on other sites

Join the conversation

You can post now and register later. If you have an account, sign in now to post with your account.

Reply to this topic...

×   Pasted as rich text.   Paste as plain text instead

  Only 75 emoji are allowed.

×   Your link has been automatically embedded.   Display as a link instead

×   Your previous content has been restored.   Clear editor

×   You cannot paste images directly. Upload or insert images from URL.


  • Create New...