Articles about troubleshooting errors in worksheets in Excel

View products that this article applies to.

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.

Back to the top

MORE INFORMATION

General troubleshooting

Why don't my errors get flagged when my workbook is protected?
279306 (http://support.microsoft.com/kb/279306/EN-US/ ) XL2002: Error Checking Not Available When Workbook Is Protected or Shared
Why aren't my array formulas flagged when they contain errors?
282163 (http://support.microsoft.com/kb/282163/EN-US/ ) XL2002: Ignored Error Flag Reappears When Worksheet Is Copied
Why are cells removed from the watch window?
282158 (http://support.microsoft.com/kb/282158/EN-US/ ) XL2002: Array Formula with Error Not Flagged

Back to the top

Formula auditing

How do I use the Formula Evaluator?
282160 (http://support.microsoft.com/kb/282160/EN-US/ ) 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 (http://support.microsoft.com/kb/289245/EN-US/ ) HOW TO: Use the Excel Formula Evaluator in Excel 2002
How do I use the Error Checking smart tag?
282140 (http://support.microsoft.com/kb/282140/EN-US/ ) XL2002: Cannot Remove Error Tracing Arrow

Back to the top