Meaningful facts and data are the basis of any successful presentation. It can, however, easily occur that old figures have snuck into your presentation. Learn how to always keep your charts up to date while simultaneously saving time!
If the data in your Excel file has changed, you have the ability to update your chart in PowerPoint with a single click. So there is the possibility to link the diagrams with Excel and thus make work easier. Under File / Information / Edit Links to Files (PPT 2016) you can also set an automatic update of the diagrams in PowerPoint.
However, when working with the standard PowerPoint feature, you often find limited possibilities. By default, charts are not automatically refreshed when the presentation is opened, and unfortunately the automatic update is not 100% reliable, so it quickly happens that changes to the Excel file are missed. The result is that your presentation is no longer up-to-date and in the worst case the wrong data is presented! In addition, one can easily lose track of several diagrams in a presentation. So it is e.g. When renaming or moving the Excel file(s) it is necessary to repair each link individually.
Are you looking for an alternative to PPT native Excel linking? Then find out more about our latest product empower® charts.