Excel chart not updating in powerpoint 2016

22 May

When you embed an Excel chart in Power Point, any updates you make to the original Excel chart will automatically update in your presentation, as long as the files remain in the same location.This helps the data stay in sync, so you won't have incorrect or out-of-date information in your chart. An Excel spreadsheet containing the chart's source data will appear.After you have finished editing, be sure to save the chart in Excel.Once you have embedded a chart, be careful not to delete or move the original Excel file.The linked excel chart method is Power Point is not well thought out! Copy the chart and in PPT choose Paste Special (Link as Excel chart) You should now have a rightc click option to update and maybe the auto update will also work.If you use code post the code you have and I will see if it can be fixed. If I copy the excel chart and link it using your method (as a chart object) it works. usually preople use code which does not correctly identify the chart object. If I copy the excel chart and link it using the Keep Source Formatting & Link Data (F) method it comes in as a macro enabled worksheet and the links don't update. If you have already created a chart in Excel, you can embed and link it to your Power Point presentation.

excel chart not updating in powerpoint 2016-13excel chart not updating in powerpoint 2016-75excel chart not updating in powerpoint 2016-26excel chart not updating in powerpoint 2016-81

I've gotten around this by creating a simple Auto_Close macro in Excel that sets the zoom factor back to 100% and saves and closes the file.

If you choose to participate, the online survey will be presented to you when you leave the Technet Web site.

Shading between plotted lines with a light color can enhance some charts.

The shading may help to indicate a target range for the data.

I’ve written earlier tutorials about this topic, but I have had to change sequences of steps in the protocol because more recent versions of Excel were not as flexible with order of operations as Excel 2003 (RIP).