How to Sync a PowerPoint Chart With Live Excel via OneDrive Link

You have a chart in Excel that updates regularly, and you want that chart to stay current in your PowerPoint presentation without manually copying it each time. PowerPoint and Excel support a live link through OneDrive that keeps the chart in sync whenever the source Excel file is updated. This article explains how to set up that live link using the Insert Object or Paste Special method with a OneDrive-stored Excel file.

The live link works because PowerPoint stores a reference to the Excel file location instead of embedding a static copy. When the Excel file on OneDrive is edited, PowerPoint can refresh the chart to show the new data. This guide covers the prerequisites, the step-by-step linking process, and common pitfalls to avoid.

How the OneDrive Link Works for PowerPoint Charts

When you insert a chart from Excel into PowerPoint using a link, PowerPoint does not copy the chart data into the presentation file. Instead, it stores a path to the Excel file on OneDrive. Every time you open the presentation or manually trigger an update, PowerPoint reads the chart from the Excel file at that path. If the Excel file has been edited, the chart in PowerPoint reflects the new data.

The link requires that the Excel file be stored on OneDrive and that you have a stable internet connection when you open the presentation. The file path is stored as a URL, not a local drive letter. If you move the Excel file to a different folder on OneDrive, the link breaks and you must repair it using the Edit Links to Files dialog.

There are two methods to create the link. The Object method inserts the entire workbook as an embedded object that shows the chart. The Paste Special method inserts only the chart as a linked picture or object. Both methods create a live connection, but the behavior differs when you right-click the chart in PowerPoint.

Steps to Link a Chart From Excel on OneDrive to PowerPoint

Method 1: Using Insert Object With a OneDrive Link

This method inserts the whole Excel workbook as a linked object. The chart appears as part of the workbook, and you can double-click it to edit the data in Excel.

1. Save the Excel file to OneDrive
   Open your Excel workbook, go to File > Save As, and choose a OneDrive folder. Make sure the file name does not contain special characters. Copy the chart you want to link to your clipboard.
2. Open the PowerPoint presentation
   Go to the slide where you want the chart to appear. Click the Insert tab on the ribbon.
3. Insert the linked object
   In the Text group, click Object. In the Insert Object dialog, select Create from File. Click Browse and navigate to the Excel file on OneDrive. Select the file and click Insert. Check the box labeled Link. Click OK.
4. Resize and position the chart
   The entire workbook appears as an object on the slide. Double-click the object to open the chart in Excel. Adjust the view so only the chart is visible, then close Excel. The chart is now linked to the OneDrive file.

Method 2: Using Paste Special to Link Only the Chart

This method inserts only the chart as a linked object. It is cleaner because the chart fills the object area without the surrounding worksheet grid.

1. Copy the chart in Excel
   Open the Excel file on OneDrive. Click the chart border to select it. Press Ctrl+C to copy the chart to the clipboard.
2. Switch to PowerPoint
   Go to the target slide. On the Home tab, click the arrow below Paste and choose Paste Special.
3. Select Paste Link
   In the Paste Special dialog, click the Paste Link radio button. From the list, select Microsoft Excel Chart Object. Click OK.
4. Move and resize the chart
   The chart appears as a linked object. You can drag it to the desired position and resize it using the corner handles. The chart updates automatically when the Excel file changes.

Common Issues With Linked Charts and OneDrive

Chart Does Not Update When Excel File Changes

If the chart in PowerPoint does not reflect the latest data, the link may be set to manual update. Go to File > Info > Edit Links to Files. In the Links dialog, select the link and click Update Now. You can also change the Update method to Automatic. If the Update Now button is grayed out, the source file path is broken.

Link Breaks When Excel File Is Moved or Renamed

Moving the Excel file to a different OneDrive folder or renaming it breaks the link. Open the Links dialog from File > Info > Edit Links to Files. Click Change Source and browse to the new file location. If the file is on a different OneDrive account, you must re-create the link from scratch.

PowerPoint Prompts for Credentials to Access OneDrive

When you open the presentation, PowerPoint may ask for your OneDrive sign-in. This happens if the Excel file is on a OneDrive account that is not signed in on the current device. Sign in with the same Microsoft account that owns the Excel file. If you use a work or school account, ensure the OneDrive sync client is active.

Linked Chart Shows a Red X or Blank Object

A red X or empty object indicates that the link is broken or the source file is inaccessible. Check that the Excel file still exists on OneDrive and that you have permission to read it. If the file was deleted, restore it from the OneDrive recycle bin. If the link is permanently broken, delete the object and re-create the link using the steps above.

PowerPoint Chart Link Methods Compared

Item	Insert Object (Link)	Paste Special (Paste Link)
What is inserted	Entire Excel workbook as an object	Only the chart as a linked object
Editing the chart	Double-click object to open full workbook in Excel	Right-click chart and select Edit Data to open source file
File size impact	Minimal because only the link is stored	Minimal because only the link is stored
Update trigger	Automatic or manual via Links dialog	Automatic or manual via Links dialog
Best use case	You need the entire workbook available from the slide	You want only the chart visible without extra worksheet elements

Both methods create a live connection to the Excel file on OneDrive. Choose Insert Object when you need to show or edit the underlying data. Choose Paste Special when you want a clean chart that matches the look of the Excel chart.

You can now link a PowerPoint chart to a live Excel file on OneDrive using either the Insert Object or Paste Special method. After setting up the link, test the update by editing a value in the Excel file and refreshing the chart in PowerPoint. For ongoing presentations, set the link update to Automatic in the Links dialog so the chart refreshes every time you open the file. If you share the presentation with others, ensure everyone has read access to the OneDrive file to avoid broken links.