Simon Sez IT

Online software training and video tutorials for Microsoft, Adobe & more

  • Course List
    • Adobe
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Flash
        • Flash CS5
      • InDesign
        • InDesign CS6
        • InDesign CS5
      • Photoshop
        • Photoshop CS6
        • Photoshop CS5
        • Adobe Photoshop CS4
      • Photoshop Elements
        • Photoshop Elements 2022
        • Photoshop Elements 2019
        • Photoshop Elements 2018
        • Photoshop Elements 15
        • Photoshop Elements 14
        • Photoshop Elements 13
        • Photoshop Elements 12
        • Photoshop Elements 11
        • Photoshop Elements 10
        • Photoshop Elements 9
        • Photoshop Elements 8
    • Microsoft
      • Access
        • Access 2021 Beginners
        • Access 2019
        • Access 2019 Advanced
        • Access 2016
        • Access 2016 Advanced
        • Access 2013
        • Access 2013 Advanced
        • Access 2010
        • Access 2010 Advanced
        • Access 2007
      • Excel
        • Data Analytics in Excel
        • Excel 2021 Advanced
        • Excel 2021 Intermediate
        • Excel 2021 Beginners
        • PivotTables for Beginners
        • Excel Dashboards
        • Advanced Formulas in Excel
        • Excel for Business Analysts
        • Advanced PivotTables
        • Power Pivot, Power Query and DAX in Excel
        • Excel 2019 Beginners (Mac)
        • Excel 2019 Beginners
        • Excel 2019 Advanced
        • Excel 2016 Beginners
        • Excel 2016 Intermediate
        • Excel 2016 Advanced
        • Excel 2013
        • Excel 2013 Advanced
        • Excel 2010 Beginners
        • Excel 2010 Advanced
        • Excel 2007
      • OneNote
        • OneNote Desktop and Windows 10
        • OneNote 2016
      • Outlook
        • Outlook 2021
        • Outlook 2019
        • Outlook 2016
        • Outlook 2013
        • Outlook 2010
        • Outlook 2007
      • Power Automate
        • Introduction to Power Automate
      • Power BI
        • Power BI
        • Power BI Intermediate
      • PowerPoint
        • PowerPoint 2021
        • PowerPoint 2019
        • PowerPoint 2016
        • PowerPoint 2013
        • PowerPoint 2010
        • PowerPoint 2007
      • Project
        • Project 2021 Beginners
        • Project for the Web
        • Project 2019
        • Project 2019 Advanced
        • Project 2016
        • Project 2016 Advanced
        • Project 2013
        • Project 2013 Advanced
        • Project 2010
        • Project 2010 Advanced
      • Publisher
        • Publisher 2013
      • SharePoint
        • SharePoint Online
        • SharePoint Foundation 2013
        • SharePoint Server 2013
        • SharePoint Foundation 2010
      • Teams
        • Microsoft Teams
      • VBA
        • Macros and VBA for Beginners
        • VBA for Excel
        • VBA Intermediate Training
      • Visio
        • Microsoft Visio 2019
        • Visio 2016
        • Visio 2013
        • Microsoft Visio 2010
      • Windows
        • Windows 11
        • Windows 10 (2020 Update)
        • Windows 10
        • Windows 8
        • Windows 7
        • Windows Vista
      • Word
        • Word 2021
        • Word 2019 Advanced
        • Word 2019
        • Word 2016
        • Word 2013
        • Word 2010
        • Word 2007
    • QuickBooks
      • QuickBooks
        • QuickBooks Desktop Pro 2022
        • QuickBooks Pro 2021
        • QuickBooks Online Advanced
        • QuickBooks Online
        • QuickBooks Canada
        • QuickBooks Pro 2020
        • QuickBooks 2019
        • QuickBooks 2018
        • QuickBooks Pro 2017
        • QuickBooks Pro 2016
        • QuickBooks Pro 2015
        • QuickBooks Pro 2014
        • QuickBooks Pro 2013
        • QuickBooks Pro 2012
        • QuickBooks Pro 2011
        • QuickBooks Pro 2010
        • QuickBooks Pro 2009
    • Web Development
      • AngularJs
        • AngularJS Crash Course
      • Dreamweaver
        • Dreamweaver CC
        • Dreamweaver CS6
        • Dreamweaver CS5
        • Dreamweaver CS4
      • Bootstrap
        • Bootstrap Framework
      • Html/CSS
        • HTML/CSS Crash Course
        • HTML5 Essentials
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
      • Java
        • Java for Beginners
      • JavaScript
        • JavaScript for Beginners
        • jQuery Crash Course
      • MySql
        • MySQL for Beginners
      • PHP
        • PHP for Beginners
        • Advanced PHP Programming
      • XML
        • XML Crash Course
    • Data Analysis
      • Financial Modeling
        • Financial Risk Management
        • Financial Forecasting and Modeling
      • Alteryx
        • Alteryx Advanced
        • Introduction to Alteryx
      • Power BI
        • Power BI Intermediate
        • Power BI
      • Qlik Sense
        • Qlik Sense Advanced
        • Qlik Sense
      • R Programming
        • R Programming
      • Tableau
        • Tableau Desktop Advanced
        • Tableau Desktop
      • Python
        • Python Object-Oriented Programming
        • Pandas for Beginners
        • Introduction to Python
    • Work Productivity
      • Google Sheets
        • Google Sheets for Beginners
      • Confluence
        • Introduction to Confluence
      • Monday
        • Getting Started in Monday.com
      • Asana
        • Asana for Employees and Managers
        • Introduction to Asana
      • Jira
        • Getting Started in Jira
  • For Business
  • About Us
    • Testimonials
    • Contact Us
    • FAQ
    • Membership
    • About Us
  • Pricing
  • Free Resources
  • Sign In
  • Get Started
Home > Microsoft PowerPoint > How to Link Excel to PowerPoint? 3 Easy Ways

How to Link Excel to PowerPoint? 3 Easy Ways

  • Facebook
  • Twitter
  • YouTube

(Note: This tutorial on how to link Excel to PowerPoint is suitable for PowerPoint 2013 and later versions including Office 365)

One of the most distinguishing features of Microsoft applications is their ability to support cross-platform functionalities. This means that you can import data from one platform to another and update them when the data in the original platform changes.

In addition to the above, Excel usually deals with large amounts of data. You will sometimes need to showcase these data in the form of PowerPoint presentations. When you create slides in PowerPoint, you will have to link the Excel sheet to PowerPoint slides for easy referral.

In this article, I will tell you how to link Excel to PowerPoint in 3 easy ways.

You’ll Learn:

  • 3 Different Ways to Link Excel to PowerPoint?
    • Link an Entire Sheet
    • Link a Section of the Excel Sheet
    • Using Paste Special Option and Linking the Data
  • Advantages of Linking Excel to PowerPoint
Download Sample PowerPoint Presentation for How to Link Excel to PowerPoint
Download Sample PowerPoint Presentation for How to Link Excel to PowerPoint

Related Reads:

How to Add Notes to PowerPoint? 6 Easy Steps

How to Superscript in PowerPoint? (And Subscript) 3 Easy Ways

How to Save PowerPoint as Video? A Step-by-Step Guide

3 Different Ways to Link Excel to PowerPoint?

Link an Entire Sheet

When presenting, you will sometimes need to provide a reference to a worksheet in Excel. In such cases, you can link an entire worksheet and open them whenever necessary. 

Before we see how to link Excel to PowerPoint, make sure you have saved the Excel workbook from which you have selected the data. 

  • To link an entire sheet, first, open PowerPoint and navigate to the slide you want to link the sheet.
  • Navigate to Insert. Under the Text section, click on Object.
How to Link Excel to PowerPoint using the Object option
How to Link Excel to PowerPoint using the Object option
  • This opens the Insert Object dialog box. In the dialog box, select the Create from file option. 
  • Click on Browse. This opens the Browse dialog box. You can now search for the workbook you want to link. Select it and click Open.
  • To link the Excel sheet with PowerPoint, check the checkbox for Link and click OK. 
Select a File and click on Link
Select a File and click on Link
  • This inserts the Excel workbook in the form of an image. You can double-click on the image to move to the original Excel file. 
The entire sheet is linked
The entire sheet is linked

When you make any changes to the original Excel file, the changes also reflect in PowerPoint.

Note: When you link an entire sheet, make sure the content you want to link is in the default sheet, which pops up when you open the Excel file. 

  • Usually, any changes you make to the Excel sheet will automatically be reflected in your PowerPoint slide. However, if you find that the PowerPoint slide is not updated, right-click on the content and click on Update Link.
Click Update Link
Click Update Link

This immediately updates the slide with the data in the linked Excel sheet.

Link a Section of the Excel Sheet

In some cases, you might not need to link the whole Excel sheet. In those cases, you can only link a section of the Excel sheet to the PowerPoint slides.

  • To link a section of the worksheet, first, open the Excel file from which you want to import the data. Make sure the Excel workbook is saved before you import data.
  • Now, select the data you want to link to the PowerPoint slides.
  • We now have to copy the selected data. To copy the data, you can either right-click and click Copy, click on the Copy option from Home, or use the shortcut key Ctrl+C.
Select the data and copy
Select the data and copy
  • Then, open PowerPoint and navigate to the slide where you want to insert the section of the Excel sheet.
  • Navigate to Home. Under the Clipboard section, click on the dropdown from Paste and select Paste Special.  
Click on Paste Special
Click on Paste Special
  • This opens the Paste Special dialog box. 
  • Click on the Paste Link radio button. And in the As: section, select Microsoft Excel Worksheet Option.  
  • Click OK.
Select Paste Link
Select Paste Link
  • This inserts the selected section into the PowerPoint slide. 
How to Insert a section of the sheet
How to Insert a section of the sheet
  • You can then use the anchor points to move or resize the section inserted in the PowerPoint slide.
  • In case the section inserted into the slide is not updated even after changing the data in Excel, right-click on the inserted section and click on the Update Link.

Using Paste Special Option and Linking the Data

Another way to link Excel to PowerPoint is by using the Paste Special option and linking the data. This method is similar to the above-mentioned method. However, this method only inserts a section of the sheet and not the whole sheet. 

  • First, navigate to the Excel sheet and select the content you want to insert. 
  • Once you have selected the data, right-click and select Copy. Or, use the keyboard shortcut key Ctrl + C.
  • After copying the data, open PowerPoint and navigate to the slide you want to insert the section to.  
  • Now, paste the copied data into the slide. Click on the dropdown from Paste in the Home main menu. Or, you can right-click on the slide and select any of the Paste Options.
  • To paste the data, you can use either of the two options:
    • Use Destination Theme & Link Data: When you use this pasting option, PowerPoint copies the data from Excel and pastes the data into the slide with the default theme of the PowerPoint slide. 
    • Keep Source Formatting & Link Data: When you copy and paste data using this option, PowerPoint pastes the data onto the slide keeping the original format of the chart intact. 
Select the Paste options and Link
Select the Paste options and Link

Remember that when you use any Paste Special Options which link Excel to PowerPoint, every change you make to the linked Excel sheet will be reflected in the PowerPoint slide.

If you want to change or edit any data, double-clicking on the slide like the above methods will not help you change the data and thereby, change the data in the slide. To change the data, right-click on the chart and select Edit Data.

Click on Edit Data
Click on Edit Data

Note: In some cases, you might not want the changes made to the Excel sheet reflected in the PowerPoint slides. In such cases, you can just copy and paste into the slides without linking them. Use the Paste Special options like Use Destination Theme & Embed Workbook, Keep Source Formatting, or Picture to copy the contents without linking them. 

Advantages of Linking Excel to PowerPoint

Excel is one of the most popular data-handling tools. On the other hand, PowerPoint is a very effective tool for presentations. To showcase Excel charts or data onto PowerPoint slides, the most sought method is to copy and paste contents from Excel to PowerPoint. However, linking Excel files to your PowerPoint slides has some advantages of its own:

  1. Linking Excel to PowerPoint makes it easy to update changes made in the Excel file onto the PowerPoint slide. This is very helpful in cases where there are numerous Excel files and you want to insert them into PowerPoint.
  2. Linking Excel to PowerPoint helps in easy references. That is, you won’t have to search through and navigate between folders to open and refer to the main source file. You can do it easily with just a click of the mouse.
  3. Linking eliminates the need for formatting every time you copy and paste the chart or data. 



Frequently Asked Questions

How do I get the data to automatically update in PowerPoint?

When you link Excel to PowerPoint using the methods we discussed, PowerPoint usually updates the data in it every time something changes in Excel. If not, you can right-click on the slide and select Update Link.

What is the easiest method to link Excel to PowerPoint?

Copying the data in Excel and using the Paste Special dialog box to select the Paste Link radio button and choosing the Microsoft Excel Worksheet Option is one of the easiest methods to link Excel to PowerPoint.

What are the ways to link a section of the Excel sheet in PowerPoint?

You can choose to link Excel to PowerPoint by navigating to Insert>Object>Create from file. Select the file you want to use and click on Link. Another way to link Excel to PowerPoint is by copying the data from Excel and pasting them onto PowerPoint using the paste special options like Use Destination Theme & Link Data or Keep Source Formatting & Link Data.

Closing Thoughts

Linking data in Excel to PowerPoint provides a sure way to keep the slides up-to-date without any manual intervention.

In this article, we saw how to link Excel to PowerPoint in 3 easy ways. If you want to link the whole worksheet, use the Object method. If you want to add a section of the sheet, use the Paste Special dialog box or use the Paste Options. Choose the method that suits your purpose the best. 

If you need more high-quality PowerPoint guides, please check out our free resources center.

Ready to dive deep into Excel? Simon Sez IT has been teaching Excel for over ten years. For a low, monthly fee you can get access to 140+ IT training courses. Click here for advanced courses with in-depth training modules.

get Alprazolam online
Simon Calder

Chris “Simon” Calder was working as a Project Manager in IT for one of Los Angeles’ most prestigious cultural institutions, LACMA. He taught himself to use Microsoft Project from a giant textbook and hated every moment of it. Online learning was in its infancy then, but he spotted an opportunity and made an online MS Project course - the rest, as they say, is history!

Most Popular Posts

  • Kanban vs Scrum: Project Management Methodologies and Their Differences [2022]
  • How to Insert a Checkbox in Excel? 3 EASY Examples
  • How to Autofit Excel Cells? 3 Best Methods
  • XLOOKUP Google Sheets – 4 Best Alternatives!
  • Dashboards in Excel Using Pivot Tables, Pivot Charts and Slicers
  • Free Microsoft Project Training Course
  • Free Microsoft Access Tutorial for Beginners (3.5 Hours Video)
  • How to Use Blending Mode With Layers in Adobe Photoshop Elements 15

Similar Posts

Formatting Calendar View in Project 2010

How to Create Excel Drop Down List With Color?

Introduction to SharePoint Online – Recorded Webinar

Excel Crash Course – Data Cleaning in Excel in 1 Hour

How to Create an Excel Slicer? 2 Easy Ways

Create Access 2013 Forms using the Form Wizard

Course Categories

  • Adobe
  • Data Analysis
  • QuickBooks
  • Microsoft
  • Web Development
  • Work Productivity

About Us

  • About Us
  • Free Resources
  • Affiliates
  • Become an Instructor

Products

  • Pricing and Plans
  • Business Pricing
  • Government Discounts
  • Non-Profit Discounts

Support

  • FAQ’s
  • Contact Us
  • DVD support

Connect

YoutubeFacebookLinkedIn
© 2023 Simon Sez IT, Inc.
  • Terms
  • Privacy Policy
  • Sitemap
888.817.6665 Monday thru Friday 7:30 a.m. - 5:00 p.m. (ET)