![]() During recalculation, Excel revises this chain if it comes across a formula that depends on a cell that has not yet been calculated. The calculation chain lists all the cells that contain formulas in the order in which they should be calculated. From this tree, Excel constructs a calculation chain. ![]() ![]() The dependency tree informs Excel about which cells depend on which others, or equivalently, which cells are precedents for which others. The calculation of worksheets in Excel can be viewed as a three-stage process: Therefore the phrase "the user" also means "the user, or a command or process started by the user." Dependence, Dirty Cells, and Recalculated Cells The user runs the command, or does something to cause the command to run so that it is still considered a user action. ![]() This topic does not distinguish between the user directly pressing a key or clicking the mouse, and those tasks being done by a command or macro.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |