Document Editing Problems

How to Fix Excel Links in PowerPoint Not Updating

Aamir Naveed Akram Sep 30, 2026 869 views

Question details

The user needs to fix an issue where linked Excel objects in a PowerPoint presentation fail to update and instead open a temporary Excel workbook.

How to Fix Excel Links in PowerPoint Not Updating

Product: Microsoft PowerPoint and Excel
Device & OS: not provided
Scenario: Pasting linked Excel worksheet objects into PowerPoint slides and attempting to update the data later.
Observed behavior: The linked Excel objects stop updating after some time. When interacting with the object, a temporary Excel workbook opens instead of the original linked file.

Before you start

Ensure both your Excel workbook and PowerPoint presentation are saved in a reliable, permanent location before creating or troubleshooting links.

Solution 1Recommended

Verify Link Sources and Enable AutoSave

If your files are stored on OneDrive or SharePoint, ensuring AutoSave is active prevents synchronization errors that can break OLE links.

Cloud-synced files rely on real-time saving to maintain active links between documents. If AutoSave is disabled, PowerPoint may lose the path to the live Excel file and revert to a cached temporary workbook.

Enable AutoSave

Open both your Excel workbook and PowerPoint presentation. In the top-left corner of the window, ensure the AutoSave toggle is turned on.

Access Link Settings

In PowerPoint, click on the 'File' tab in the top ribbon and navigate to 'Info'.

Edit Links to Files

Scroll down to the bottom right and click on 'Edit Links to Files'. This option only appears if the presentation contains linked objects.

Verify Source Path

In the Links dialog box, check the source path for your Excel worksheet. If the path is incorrect or points to a temporary folder, click 'Change Source' to reselect the correct OneDrive or SharePoint file.

Sync Completion: Allow a few moments for OneDrive or SharePoint to fully sync both files after re-establishing the link before attempting to update the data again.

Solution 2

Repair the Microsoft Office Installation

If the linking issue occurs exclusively with locally stored files, your Office installation may have corrupted OLE registry keys.

Solution 3

Re-insert the Linked Excel Object

Sometimes existing links become irreparably broken and need to be pasted fresh using the correct Paste Special method.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet and Presentation Integration

If you are frequently frustrated by broken OLE links, synchronization bugs, or temporary file errors in Microsoft Office, consider switching to WPS Office. It offers a unified interface where your documents, spreadsheets, and presentations work seamlessly together without complex linking issues.

1. Download and Install: Get the free WPS Office installer from the official website and run it on your device.
2. Open Your Files: Launch WPS Office and open your existing .pptx and .xlsx files directly. No conversion is required.
3. Work Seamlessly: Use the all-in-one tabbed workspace to easily copy and paste data between your spreadsheet and presentation.

Free and lightweight office suite with lower system requirements.Seamlessly integrates presentations, spreadsheets, and PDFs in a single tabbed window.Fully compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formats.Stable copy-pasting and data management without unexpected temporary file errors.

microsoft office alternative - wps office

Frequently Asked Questions

Why does PowerPoint open a temporary Excel file when I double-click a linked object?

This happens when PowerPoint loses the exact file path to the original Excel workbook, or if the original workbook is locked by another process. Instead of failing entirely, PowerPoint opens a cached temporary version of the data embedded in the slide.

Does moving my files break the Excel links in PowerPoint?

Yes. OLE links generally rely on absolute file paths. If you move either the Excel file or the PowerPoint file to a different folder or cloud drive, the link will break. You must manually update the path by going to File > Info > Edit Links to Files.

How do I force PowerPoint to update all Excel links at once?

You can force an update by navigating to File > Info > Edit Links to Files. In the dialog box, highlight all the links in the list (using the Shift key) and click the 'Update Now' button.

What is the difference between 'Paste' and 'Paste Link'?

Standard 'Paste' embeds a disconnected copy of the Excel data into PowerPoint; changes in Excel will not reflect in PowerPoint. 'Paste Link' creates an active connection, meaning any changes saved in the original Excel file will automatically update on the PowerPoint slide.

Document & File Issues