Excel/Powerpoint

Resolved · Medium Priority · Version 2010

Wed 21 Jun 2017, 12:07 Delegate Louisa said...

Louisa has attended:
Excel Intermediate course

Excel/Powerpoint

Hi,

I am trying to merge data between Excel and Powerpoint and have forgotten the best way to do this.
I have got data and a graph in Excel which I want to put into Powerpoint without using copy and paste each time. I want to be able to change the data in Excel so that it automatically updates the data in Powerpoint.

Wed 21 Jun 2017, 14:56 Trainer Marius said...

RE: Excel/Powerpoint

Hello Louisa,

Thank you for your question. The best way to link data and charts between Excel and PowerPoint is to copy the Excel content, then go to PowerPoint and click the drop-down section of the Paste button in the Home ribbon. Now, select "Paste Special". In the Paste Special box, select the "Paste link" option on the left.

The box will tell you that it recognises the data as either a Worksheet object or a Chart object. Click OK.

From this point on, any changes made to the Excel data / chart will automatically update in PowerPoint. If PowerPoint is closed when you make the Excel changes, it will update the next time you open the PowerPoint file.

I hope this is helpful.

Kind regards
Marius Barnard
STL

Training courses

	98.7 % recommend us
	More live stats...

Training information:

Excel tip:

Highlighting only Text cells

To select onlt text value cells in a spreadsheet, click on Edit-Go to(F5)

In the Go To dialog box, click Special.
In the Go To Special dialog box, select Constants.
Click OK.

View all Excel hints and tips