Updating formulas in excel
Microsoft is conducting an online survey to understand your opinion of the Technet Web site.
If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.
This mode keeps the Power Pivot metadata in synch, and prevents problems caused by deletion of data, changes in names or data types, or missing dependencies.
When you use automatic recalculation mode, any changes to data in the workbook that would cause the result of any formula to change will trigger recalculation of the entire column that contains a formula.
For more information, see means updating all the columns, tables, charts, and Pivot Tables in your workbook that contain formulas.Supposing you have created a chart to track the daily sales based on a range of data in your workbook.