Keeping Office up-to-date ensures that you have the latest security updates and fixes.
If you're an Office 365 subscriber, you'll also get new and improved features. See Check for Office for Mac updates automatically.
When you update the underlying data of a chart, the chart's data and appearance also changes.
The extent of those changes depends on how you define the chart's data source.
Get up and running quickly with familiar navigation and formulas, while maintaining the same formatting across all your devices.
With the Excel mobile app, your Office moves with you.
If the workbook that you have opened (called a destination file) contains links to other workbooks or files (called source files), and the source files have changed, then the links in workbook that you are opening may display information that is out of date. The destination workbook contains the external reference. The external reference (or link) is a reference to a cell range in the source workbook. The source workbook contains the cell and the actual value that is retrieved and placed in the destination workbook.You can control whether the Trust Bar alerts you, and whether to update all links when the alert does not appear.You can also update only some of the links, if the workbook contains more than one link. It is possible to accidentally create a link by moving or copying a range, worksheet, or chart between workbooks.With calculation options set to automatic (Microsoft Office Button , Excel Options, Formulas category or Formulas tab, Calculation group, Calculation Options button), changes that you make to the worksheet data automatically appear in the chart.If you create a chart based on a cell range, updates to data within the original range are reflected in the chart.