How to link a part of data in Excel Worksheet in Microsoft PowerPoint

To make a PowerPoint presentation look more realistic, Office users can link an Excel worksheet in it. It has many benefits. One, it serves a valuable skill since it allows data to be presented in a more lucid and easy to comprehend manner. Second, it helps to avoid any mismatch of information in your report as the changes you make are instantly reflected in the presentation, so long the files share the original location.

If you are curious to know how to embed an Excel Worksheet in PowerPoint presentation, pause for a moment and read further.

Link Excel Data in PowerPoint Presentation

Before proceeding any further and diving into the main steps of the tutorial it is important to mention that the terms ‘EMBEDING’ and ‘LINKING’, though sound similar and interchangeable are quite different.

Launch Microsoft Excel and open the saved workbook with the data you want to insert and link to.

Next, select a section by dragging over the area of data and hit ‘Copy’ button visible under the ‘Home’ tab.

Link Excel Data in PowerPoint Presentation

Now, switch to your PowerPoint presentation and click the slide where you would like to paste the copied worksheet data.

Then, on the Home tab, click the arrow below Paste, and select Paste Special.

When seen, choose ‘Paste link’ under ‘Paste Special’ heading, and then, under ‘As’, select Microsoft Excel Worksheet Object.

Also, if you would like to link an entire Excel worksheet to PowerPoint, go to a PowerPoint presentation, choose the Insert tab and click or tap Object.

In the Insert Object dialog box that opens, select Create from file option.

Thereafter, click or tap Browse, and in the Browse box, find the Excel workbook with the data you want to insert and link to. Check the ‘Link’ option adjacent to the ‘Browse’ button.

That’s it!

Posted by on , in Category Office with Tags
The author Hemant Saxena is a post-graduate in bio-technology and has an immense interest in following Windows, Office and other technology developments. Quiet by nature, he is an avid Lacrosse player. Creating a System Restore Point first before installing a new software, and being careful about any third-party offers while installing freeware is recommended.

Leave a Reply

Your email address will not be published. Required fields are marked *

8 + 5 =