Disclosure: This post may contain affiliate links, meaning when you click the links and make a purchase, we receive a commission.

How to Link Powerpoint to Excel for Dynamic Data Updates

We often need to show live data or real-time scores in Powerpoint presentations. This type of data changes frequently. Therefore, it is inefficient to change excel data manually and then make a Powerpoint slide each time there is a change in the data. In this article, I will show you three handy methods to link Powerpoint to Excel files for dynamic data updates.


Download Practice Workbook

Download this practice workbook for practice while you are reading this article.


3 Easy Methods to Link Powerpoint to Excel for Dynamic Data Updates

In this article, we will learn 3 quick ways to link an Excel Table or chart to Powerpoint to update data dynamically. For this purpose, we will use the following dataset.

Link Powerpoint to Excel for Dynamic Data Updates


1. Use Automatic Update Option in Powerpoint

This method will demonstrate how you can use the Edit links to Files feature for automatic data update.

Steps:

  • Firstly, Hold the left mouse key and drag it to highlight your Table in Excel.
  • Then right-click the mouse key and select Copy.

Link Powerpoint to Excel usicng Automatic Update Option

  • Open your MS Powerpoint. On the left top corner, click on the down arrow under the Paste icon.
  • Now we will select a special type of paste option. To do that,  select Paste Special. A pop-up box will open.

  • Click on the Paste Link in the pop-up and choose Microsoft Excel Worksheet Object option.
  • Then click OK.

Link Powerpoint to Excel using Paste Link

  • Now we have to automate the whole operation. For that, Click on File on the top left corner of your Powerpoint.

  • Then select the Info option.

How to Link Powerpoint to Excel using info option

  • Click on the Edit Links to Files. A pop-up will open.

Link Powerpoint to Excel using Edit Links to Files

  • In the pop-up, choose the link to your Excel Table.
  • Then check the Automatic Update option.
  • You can also click on the Update now option to update the data manually.

Link Powerpoint to Excel using Automatic Update

  • In the following Figure, we can see that the Quantity of Ice cream was 840 initially.

  • We changed the value to 1000 in Excel and the value is automatically updated in Powerpoint. So we can see that our method is working perfectly and now we are able to link PowerPoint to excel for dynamic data updates.Link Powerpoint to Excel using Automatic Update
Notes: If the data does not update automatically, select the Update now option to instantly update data.

Read More: How to Perform Excel to PowerPoint Automation (With Easy Steps)


2. Apply Paste Special Link Feature to Link for Dynamic Data Updates

In this method, we will learn the quickest and easiest way of linking Powerpoint to Excel to update data automatically.

Steps:

  •  At first, Copy the Table from Excel.

Link Powerpoint to Excel using Paste Special Link

  • Now open Powerpoint.
  • Click on the down arrow under the Paste option in Powerpoint top left corner.
  • After that, choose Paste Special to open a pop-up box.

  • Click on the Paste link and then select Microsoft Excel Worksheet Object.
  • Now press Ok to complete copying the table.

Link Powerpoint to EXcel using Paste special Link

  • The copied Table will appear in Powerpoint.
  • Save the file and close Powerpoint.

  • To link the table with Excel, Change any data in the Excel file and reopen Powerpoint.
  • Now, a pop-up box will appear.
  • Now click on Update Links. It will update any change made in the Excel file.

Link Powerpoint to Excel using Paste special Link

Notes: Each time you open the Powerpoint file, the pop-up will open. Therefore, you will have to press Update Links to keep the data updated.

Read More: How to Copy Chart from Excel to PowerPoint Without Link


Similar Readings


3. Use Regular Paste Option to Link Powerpoint to Excel

In this method, I will show you how you can keep the original file format and the default file format of Powerpoint.

Steps:

Link Powerpoint to Excel using Regular Paste

  • Next, open Powerpoint and click on the down arrow under Paste at the top left corner.
  • Then, Select Use Destination Theme from Paste Options.

  • It will change the Format to Default Powerpoint Format.

Link Powerpoint to to Excel using Destination Theme

  • You can also choose the Keep Source Formatting.

  • This will keep the Format of the Excel file.

Link Powerpoint to Excel using Keep Source Formatting

  • Now any data alteration in Excel will automatically update the data in Powerpoint.
  • To see that it works, go to Excel and change any data.
  • Here, we changed the value for Quantity of Ice cream from 980 to 1220 in Excel.

Link Powerpoint to Excel charts for Dynamic Data Updates

  • The Excel file is linked to Powerpoint. Therefore, this change automatically updated the Chart data in Powerpoint.

Link Powerpoint to Excel Charts for Dynamic Data Updates

  • If the Chart data does not get updated, click on the Chart Design tab and press Refresh Data.

Link Powerpoint to Excel Charts for Dynamic Data Updates

Notes: There is a drawback to this method. If you move the Excel file to a different folder, the link between Excel and Powerpoint will be broken.

Read More: Automatically Create PowerPoint Slides from Excel (3 Easy Ways)


Concluding Remarks

Thanks for making it this far. I hope you find this article useful. You can now link Excel to Powerpoint for dynamic data updates. Please let us know if you have any further queries and feel free to give us any recommendations in the comment section below.


Related Articles

Alif Bin Hussain

Alif Bin Hussain

Hello! Welcome to my Profile. Currently, I am working and doing research on Microsoft Excel and here I will be posting articles related to this. My last educational degree was BSc and my program was Civil Engineering from Bangladesh University of Engineering & Technology (BUET). I am a fresh graduate with a great interest in research and development. I do my best to acquire new information and try to find out the most efficient solutions.

We will be happy to hear your thoughts

Leave a reply

ExcelDemy
Logo