Office Compatibility Issues

Fix Linked Excel Table Not Updating in PowerPoint Slide Show

Camila Milosovich Oct 21, 2026 868 views

Question details

The user needs to understand why an Excel table linked to a PowerPoint presentation dynamically updates in editing mode but fails to refresh during Slide Show mode.

How to Fix Linked Excel Table Not Updating in PowerPoint Slide Show

Product: PowerPoint, Excel
Device & OS: not provided
Scenario: Displaying a dynamic, continuously updating list or table on a large screen during a live presentation.
Observed behavior: The linked Excel data updates normally while the presentation is in Normal view, but it stops refreshing as soon as Slide Show mode is activated.

Before you start

Ensure that both your Excel workbook and PowerPoint presentation are saved in a stable, shared network or local folder, and that neither file is restricted by read-only permissions.

Solution 1Recommended

Refresh Data Before Presenting and Verify Link Settings

Manually refreshing the data before starting the presentation is the most reliable native workaround, as continuous live updates in Slide Show mode are limited by the software.

PowerPoint OLE (Object Linking and Embedding) links are designed to fetch data continuously in Normal view. However, during a Slide Show, the application prioritizes rendering and performance, suspending the background polling required to update linked Excel files live. This is a known system limitation.

Open Normal View

Launch your PowerPoint presentation and ensure you are in the standard editing mode.

Update the Link Manually

Navigate to the slide containing the linked Excel table, right-click on the table or chart, and select 'Update Link' to fetch the latest data just before presenting.

Check Link Properties

Go to 'File' > 'Info' > 'Edit Links to Files'. Verify that the Excel source file path is correct and set the update method to 'Automatic'.

Consider Third-Party Add-ins

If you strictly require continuous live data updates on a display screen during an active slideshow, search the Microsoft Add-in store for specialized third-party data-refresh tools designed for PowerPoint.

Refresh Data Before Presenting and Verify Link Settings

Submit Feedback to Microsoft: You can request native support for live Slide Show updates by navigating to File > Feedback > Send a Suggestion within your PowerPoint application.

Solution 2

Verify Network Access and Keep Slides Updated Feature

Check if Microsoft 365 collaboration features are enabled and ensure no connection issues are blocking the data source.

Free Microsoft Office alternative

Try WPS Office for Seamless Document Compatibility

While updating links continuously during a live presentation is a known limitation in standard Microsoft Office tools, you can explore WPS Office as a free, lightweight, and highly compatible alternative for your daily spreadsheet and presentation tasks.

1. Download and Install: Visit the official WPS Office website to download the free suite and install it on your device.
2. Open Your Presentation: Launch WPS Presentation and open your existing .pptx files to enjoy a familiar, smooth presenting experience.
3. Manage Linked Data: Use the integrated tools to insert, update, and manage your embedded spreadsheet data efficiently.

Fully compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formats.Free, lightweight suite with a familiar UI for seamless migration.Easily link, manage, and present charts and tables across different documents.

Frequently Asked Questions

Can I make an Excel table update automatically during a PowerPoint slideshow without third-party tools?

Natively, PowerPoint does not support continuous live updating of OLE links while in Slide Show mode. The data will usually only refresh while you are in Normal (editing) view. You must manually update the link before presenting or use a specialized add-in.

Why does my linked chart update when editing but freeze when presenting?

Slide Show mode is designed to render a static, high-performance snapshot of your slides to ensure smooth playback. Because of this, the continuous background polling required to check for Excel data changes is suspended during the live presentation.

How do I fix broken Excel links in my presentation?

To fix a broken link, go to File > Info > Edit Links to Files. Select the link that is no longer working, click 'Change Source', and navigate to the new or corrected location of your Excel workbook.

Office App Problems