When presenting financial data, project timelines, or sales figures in a Microsoft PowerPoint presentation, it is common to simply copy and paste a static image of an Excel spreadsheet onto a slide. However, if the underlying data changes minutes before your presentation, your static image is instantly outdated. Updating it requires opening Excel, taking a new screenshot, deleting the old image in PowerPoint, and trying to align the new one perfectly.
To avoid this stressful scenario, you can embed a “live” Excel spreadsheet directly into your PowerPoint slide. By linking the two files, any changes you make to the data or formatting in the original Excel file will automatically and instantly update within your presentation.
Linking an Excel File to PowerPoint
To create a live link, both your Excel file and your PowerPoint presentation must be saved on your computer (or OneDrive). You cannot link to an unsaved workbook.
- Open your completed spreadsheet in Microsoft Excel.
- Click and drag your mouse to highlight the specific cells, tables, or charts you want to appear in your presentation.
- Press Ctrl + C (or right-click and select Copy) to copy the data.
- Open your presentation in Microsoft PowerPoint and navigate to the slide where you want the data to appear.
- Click on the Home tab in the top ribbon menu.
- Do not just press Ctrl + V. Instead, click the small downward-facing arrow directly beneath the large Paste button on the far left side of the ribbon.
- Select Paste Special from the dropdown menu.
- A dialog box will appear. On the left side of the box, select the radio button labelled Paste link.
- In the central list, ensure Microsoft Excel Worksheet Object is selected.
- Click OK.
Managing the Live Link
Your Excel data will now appear on your PowerPoint slide. You can click and drag the edges to resize it, just like a normal image. However, it is fundamentally different from a static screenshot.
- To test the connection, leave PowerPoint open and switch back to your Excel window.
- Change a number, alter a cell’s background colour, or update a formula in the Excel file.
- Switch back to PowerPoint. You will see that the spreadsheet on your slide has instantly updated to reflect the new data.
Crucial Warning: Because the files are linked, you must keep them together. If you email the PowerPoint file to a colleague without also sending the Excel file (and ensuring the file paths remain identical), the link will break, and the spreadsheet will freeze as a static image based on its last known state. If you plan to present on a different computer, it is highly recommended to place both files in the same folder before creating the link, and then move the entire folder together.