Trace Errors in Your MS Excel Spreadsheets
- by Carol Bratt on 20090226 @ 02:19PM EST | google it | send to friends
- Filed under Carol's Corner Office | (related terms: error message, cell, information, formula, tools auditing)
I hate it when an error message shows up in my Excel spreadsheets! Doesn't everyone? When you see an error message it generally means that somehow, somewhere, a typo has made its way into one of your formulas or a piece of information is either incorrect or missing.
If you were the author of the formula that is returning the error, you may not have too much difficulty in determining where the trouble is located. However, if you are working in someone else's spreadsheet, it may not be as readily apparent. That is when you use the Auditing Tools in MS Excel to sniff out the cause of the error.
Follow the steps below to make the fix:
- Click on the cell that contains the error message to select it. Click on Tools | Auditing | Trace Error.
- When you do this, MS Excel will draw an arrow to the cell that contains the error, from every cell that the formula references.
- You can then see at a glance which cells you need to audit to confirm that they contain the correct information.
- After you have audited the problem, remove the arrows by following the instructions below:
- Click on Tools | Auditing | Remove All Arrows.
Pretty nifty, eh?
When you become a member at CarolsCornerOffice.com, you have access to this and many, many more articles that include screenshots. Don't delay: visit us today!
