Logo Questions Linux Laravel Mysql Ubuntu Git Menu
 

Is there a way to tell PowerPoint not to open Excel when creating charts?

Tags:

People also ask

Can you unlink PowerPoint chart from Excel?

To unlink PowerPoint Chart from Excel, go to the “edit links to files” tab. This can be found under the “File” tab. Select the links that you want to break and you are done. Before unlinking the chart in PowerPoint from Excel, it is best to save a copy of the project.

How do I freeze a chart from Excel in PowerPoint?

Here is another way to do it: In Excel select one of the series on the chart, then select the whole SERIES formula on the Formula Bar and press F9, Enter. Do this for each series. The chart will now be static.

How do I stop my Excel chart from updating in PowerPoint?

Click Formulas > Calculation Options > Manual, then when updating the original data in the range, the chart won't update anymore.


Slide.Shapes.AddChart() automatically opens Excel. Even if I quickly do Chart.ChartData.Workbook.Application.Visible = false, it still shows a little while. This makes automating chart creation error-prone as the user has to try not to touch the Excel applications that keeps popping up.

Opening a presentation with WithWindow = false will still open Excel when creating new charts.