File Sharing Problems

How to Link an Online Excel Workbook to a Local PowerPoint

Maira Mehtab Sep 20, 2026 868 views

Question details

The user needs to create a dynamic link between a shared online Excel workbook, which they have edit permissions for but do not own, and a locally stored PowerPoint presentation.

Product: Excel, PowerPoint, OneDrive
Device & OS: not provided
Scenario: Linking data from a cloud-hosted shared spreadsheet into a local slide deck so that the presentation updates when the spreadsheet changes.
Observed behavior: The user wants the local PowerPoint presentation to maintain a stable, updatable data link to the shared online workbook.

Before you start

Ensure that the OneDrive desktop application is installed and that you are signed in with the account that has permissions to access the shared Excel workbook.

Solution 1Recommended

Sync the Excel Workbook via OneDrive and Link Locally

By synchronizing the shared online workbook to your local OneDrive folder, you create a stable local file path that PowerPoint can use to establish and update the data link.

PowerPoint requires a local file path to reliably link data from external spreadsheets. Directly linking a URL from Excel Online often fails or disables the 'Paste Link' option. Syncing the file bridges the gap between the cloud and your local software.

Sync the shared file to OneDrive

Open the shared Excel workbook online. In the menu or toolbar, select the 'Sync' or 'Add shortcut to My files' option to make the workbook available in your local OneDrive directory.

Open the local synced copy

Open File Explorer on your computer, navigate to your OneDrive folder, and double-click the synced Excel workbook to open it in the desktop version of Excel.

Copy the desired data

Highlight the specific cells, range, or chart in the Excel workbook that you want to include in your presentation, right-click, and select 'Copy'.

Paste Special in PowerPoint

Open your local PowerPoint presentation and navigate to the target slide. Click the drop-down arrow under the 'Paste' button on the Home tab, select 'Paste Special', choose 'Paste link', and click 'OK'.

Do Not Move the Synced File: PowerPoint remembers the exact local OneDrive path. Moving or renaming the synced Excel file within your File Explorer will break the link.

All-in-One Office Workspace

Seamlessly Link Spreadsheets and Presentations with WPS Office

If you are looking for an easier way to manage linked files, WPS Office offers a unified workspace where Spreadsheets and Presentations work together flawlessly. Using the built-in WPS Cloud, you can easily share, sync, and link documents without worrying about broken paths.

1. Upload your Spreadsheet to WPS Cloud: Save your spreadsheet directly to WPS Cloud from within WPS Office and share it with your collaborators.
2. Copy the data range: Open the cloud-saved spreadsheet in WPS Office, select the cells or chart you want to link, and press Ctrl+C to copy.
3. Paste as a link in your Presentation: Switch to your presentation tab in WPS Office, navigate to 'Home', click the 'Paste' drop-down, select 'Paste Special', and choose 'Paste Link'.
4. Keep data updated automatically: Because both files are managed within the WPS ecosystem, any updates made by collaborators to the cloud spreadsheet can be seamlessly refreshed in your presentation.

Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) formats.Built-in WPS Cloud ensures your shared files are always synced across devices.Manage spreadsheets and presentations side-by-side in a single, tabbed window.Lightweight and free to use, offering a seamless alternative for office tasks.

How to Link or Embed Excel Data in PowerPoint and Keep It Updated

Frequently Asked Questions

Why is the 'Paste Link' option grayed out in PowerPoint?

The 'Paste Link' option requires the source data to come from a saved, local file. If you are copying data directly from Excel Online in your web browser instead of a synced desktop file, PowerPoint cannot establish a local link, and the option will be unavailable.

Do I need to be the owner of the online Excel file to link it?

No, you do not need to own the file. As long as you have view or edit permissions and can successfully sync the file to your local computer via OneDrive, you can create a working link in PowerPoint.

How do I update the PowerPoint links if the Excel file is modified?

When you open the PowerPoint presentation, it will usually prompt you to update links automatically. Alternatively, you can go to 'File' > 'Info', click 'Edit Links to Files' in the bottom right corner, select your Excel link, and click 'Update Now'.

Document & File Issues