Microsoft KB Archive/293412

= Articles about troubleshooting errors in worksheets in Excel =

Article ID: 293412

Article Last Modified on 1/31/2007

-

APPLIES TO


 * Microsoft Office Excel 2007
 * Microsoft Office Excel 2003
 * Microsoft Excel 2002 Standard Edition

-



This article was previously published under Q293412



SUMMARY
It can be challenging to find the cause of error messages in Microsoft Excel worksheets. This article lists many Microsoft Knowledge Base articles about troubleshooting error messages in Excel worksheets.



General troubleshooting
 Why don't my errors get flagged when my workbook is protected?

279306 XL2002: Error Checking Not Available When Workbook Is Protected or Shared

 Why aren't my array formulas flagged when they contain errors?

282163 XL2002: Ignored Error Flag Reappears When Worksheet Is Copied

 Why are cells removed from the watch window?

282158 XL2002: Array Formula with Error Not Flagged



Formula auditing
 How do I use the Formula Evaluator?

282160 XL2002: Cell Is Removed from Watch Window When You Cut and Paste into a Watched Cell

 How do I remove the error tracing arrows?

289245 HOW TO: Use the Excel Formula Evaluator in Excel 2002

 How do I use the Error Checking smart tag?

282140 XL2002: Cannot Remove Error Tracing Arrow

</li></ul>

<div class="references_section">