Picking up data from Excel

Hello Julia,

Hope you enjoyed your Microsoft PowerPoint Intermediate Advanced course with Best STL.

Thank you for your question regarding picking up data from Excel through PowerPoint.

Firstly, make sure that you have both the Excel and PowerPoint files open. Then from the Excel file click the cell holding the value to be viewed in PowerPoint and copy it, then in PowerPoint navigate to the slide where this item is to be pasted and from the Home ribbon in the Clipboard group (left side) click the paste drop-down and choose paste special. This opens a dialogue box where you can choose Paste Link and Microsoft Excel Worksheet Object is selected and then click OK.

You can format the item in Excel and this will carry through to PowerPoint. The item in PowerPoint can be moved to any position on the slide and can be resized if required.

Making any changes in Excel will update the item in PowerPoint providing both files are open. If you close PowerPoint and edit the linked cell in Excel and then save the file, when you next open PowerPoint you will be reminded that the file has links and you will be asked if you wish to update the links. Doing so will then show the same value in PowerPoint as you have in Excel even if the Excel file is closed.

In PowerPoint you can double click the inserted item which will open the Excel file where the data can be edited.


I hope this resolves your question. If it has, please mark this question as resolved.

If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Office question?

Have a great day.
Regards,

Rodney
Microsoft Office Specialist Trainer