Microsoft Excel might show ##### in cells when a column isn’t wide enough to show all of the cell contents. Formulas that return dates and times as negative values can also show as #####.

Formulas can sometimes result in error values in addition to returning unintended results. The following are some tools that you can use to find and investigate the causes of these errors …

How to use the IFERROR function in Excel to trap and handle errors in a formula.

Recover a corrupted workbook manually when Excel can't start File Recovery mode automatically and learn about saving backup and recovery files to prevent losing your work.

#VALUE is Excel's way of saying, "There's something wrong with the way your formula is typed. Or, there's something wrong with the cells you are referencing." The error is very general, and …

Here’s how: Click Open in Excel and use error checking to detect errors in formulas. For news about the latest Excel Online updates, visit the Microsoft Excel blog. For the full suite of Office …

How to correct a #SPILL error in Excel (when a formula returns multiple results and cannot return them to the grid).

The top reason why the #NAME? error appears in your formula is because there is a typo in the formula name. To avoid typos in formula names, use the Formula Wizard in Excel.

This means that if an entire column is given as the lookup_value argument, Excel will attempt to lookup all 1,048,576 values in the column. Once it's done, it will attempt to spill them to the …

A #CONNECT error occurs when a formula can't connect to a required resource. See the following: General