If the ERROR.TYPE function in Excel not working for you, ensure the formula is correct, check for errors in the referenced cell, or repair Excel.

This article looks at how to use Excel’s auditing tools to audit formulas and ensure the accuracy of data.

Excel can throw up various Data type Refresh errors. This post explains each and shows how to fix COULDN'T REFRESH DATA TYPES errors.

Q. I have an Excel spreadsheet that contains errors because some of the numbers that are part of the calculations are blank or zero. Is there a way to have Excel automatically return something instead ...

What's unusual here is that someone checked it," says Ray Panko, a professor at the University of Hawaii and the elder statesman of small coterie of research academics who study—yes—Excel errors.