Last modified: July 01, 2011 Applies to: Excel 2013 Office 2013 Visual Studio In this article The user can trigger recalculation in Microsoft Excel in several ways, for example: • Entering new data (if Excel is in Automatic recalculation mode, described later in this topic). • Explicitly instructing Excel to recalculate all or part of a workbook. • Deleting or inserting a row or column. • Saving a workbook while the Recalculate before save option is set. • Performing certain Autofilter actions. • Double-clicking a row or column divider (in Automatic calculation mode). • Adding, editing, or deleting a defined name.

• Renaming a worksheet. Gemvision Matrix Free Rapidshare. • Changing the position of a worksheet in relation to other worksheets. • Hiding or unhiding rows, but not columns. The calculation of worksheets in Excel can be viewed as a three-stage process: • Construction of a dependency tree • Construction of a calculation chain • Recalculation of cells The dependency tree informs Excel about which cells depend on which others, or equivalently, which cells are precedents for which others. From this tree, Excel constructs a calculation chain. The calculation chain lists all the cells that contain formulas in the order in which they should be calculated. During recalculation, Excel revises this chain if it comes across a formula that depends on a cell that has not yet been calculated.