When you work with Excel, you work with numbers and calculations. As you learn in the Excel section of this book (Part V), Excel is a number cruncher. It is built to do math and provide you with correct results when it does calculations.
Two of the options that you might want to adjust related to Excel specify when it recalculates all the formulas in an Excel workbook and the rules that it uses to check for errors in an Excel worksheet.
Follow these steps: