Chart & Visualization Issues

How to Fix Excel Chart Links in PowerPoint with OneDrive Collaboration

Emma Brown Oct 20, 2026 868 views

Question details

The user needs to resolve synchronization and access errors when updating linked Excel charts within a PowerPoint presentation stored on OneDrive.

How to Fix Excel Chart Links in PowerPoint Using OneDrive Collaboration

Product: Microsoft PowerPoint and Excel
Device & OS: not provided
Scenario: Collaborating on a PowerPoint presentation containing linked Excel charts stored in a shared OneDrive or SharePoint folder.
Observed behavior: When attempting to update chart data, PowerPoint displays errors such as 'the Excel file is open elsewhere,' 'cannot be accessed,' or 'file unavailable,' and fails to open the correct shared workbook.

Before you start

Ensure both your Excel workbook and PowerPoint presentation are fully synced to OneDrive and that you have the desktop versions of the Office applications installed.

Solution 1Recommended

Edit Linked Charts Using Desktop Office Applications

PowerPoint for the web has strict limitations with linked external data. Opening the files in desktop applications usually bypasses web sync conflicts and resolves access errors.

Web versions of Office applications handle file linking differently than their desktop counterparts. If you attempt to update data via Chart Design > Select Data in the browser, PowerPoint may struggle to locate the SharePoint-linked Excel file.

Open files in the Desktop App

Navigate to your shared OneDrive folder online, click the three dots next to your PowerPoint file, and select 'Open in Desktop App'. Do the same for your Excel workbook.

Update the chart data

In the desktop version of PowerPoint, select the linked chart, navigate to the 'Chart Design' tab, and click 'Select Data'. Ensure the Excel file opens smoothly in the background.

Save and sync

Once your edits are complete, save the presentation. Ensure the AutoSave toggle is on so your changes are synced back to OneDrive.

Edit Linked Charts Using Desktop Office Applications

Collaboration Locks: If another user is actively modifying the exact same chart data in the shared Excel file, you may still receive a 'file is open elsewhere' prompt. Wait for them to finish before updating.

Solution 2

Recreate Outdated or Broken Excel Links

If files were originally created locally and then uploaded to OneDrive, the old local links might break or point to incorrect paths.

Solution 3

Adjust Microsoft 365 Collaboration Policies

Organizational policies configured by IT administrators might prevent certain file-sharing behaviors or shared workbook modifications.

Free Microsoft Office alternative

Create and Link Charts Seamlessly with WPS Office

Avoid frustrating OneDrive sync errors and web app limitations. WPS Office provides a robust, lightweight desktop experience for linking spreadsheet charts to presentations, fully compatible with Microsoft Office formats.

1. Download and Install WPS Office: Get the free WPS Office suite from the official website and install it on your device.
2. Open your files: Open your .xlsx spreadsheet and .pptx presentation directly in WPS Office.
3. Paste and link your chart: Copy the chart from WPS Spreadsheet, right-click in WPS Presentation, and select Paste Special > Paste Link to keep your data synced seamlessly.

Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) formatsSeamlessly paste and link spreadsheet charts to presentations locallyLightweight desktop app without complex cloud sync lockoutsFree to download with an intuitive, familiar user interface

microsoft office alternative - wps office

Frequently Asked Questions

Why does PowerPoint say the linked Excel file is open elsewhere?

This occurs in OneDrive when another collaborator is editing the linked Excel file, or if the web application's active background syncing process locks the file from being accessed by PowerPoint. Using the desktop app or waiting for the sync to finish usually resolves this.

Can I update linked Excel charts in PowerPoint for the web?

PowerPoint for the web has strict limitations regarding external data links and often cannot execute cross-file queries. It is highly recommended to open the presentation in the desktop version of PowerPoint to update linked Excel charts.

How do I check where my PowerPoint chart is linked?

In the desktop version of PowerPoint, navigate to File > Info > Edit Links to Files. This menu displays all linked objects, including your Excel charts, and their current file paths, allowing you to manually update the source or break the links if necessary.

Excel & Data Problems