How to Fix PowerPoint for the Web Not Updating Linked Excel Data
Question details
Users are unable to refresh or update linked Excel data when viewing or editing a presentation in PowerPoint for the Web.
- Product
- PowerPoint for the Web
- Device & OS
- not provided
- Scenario
- Viewing or presenting a PowerPoint file online that contains linked Excel objects or charts.
- Observed behavior
- Linked Excel data does not update automatically in the web version, showing outdated values instead of the latest numbers.
Ensure you have access to the desktop version of PowerPoint and that the linked Excel source file is accessible and updated.
Update Linked Data Using the PowerPoint Desktop Application
Since PowerPoint for the Web has limited functionality for linked objects, you must use the desktop app to pull the latest Excel data.
PowerPoint for the Web currently does not support the automatic or manual refreshing of linked Excel objects. This is an expected limitation of the web-based version. To reflect the latest data, the file must be opened and refreshed in the full desktop application.
Open the presentation in PowerPoint for the Web, then click on the 'Editing' dropdown menu and select 'Open in Desktop App'.
Once the presentation opens in the PowerPoint desktop application, navigate to the slide with the linked Excel data. Right-click the linked chart or object and select 'Update Link'.
Ensure AutoSave is enabled in the top left corner, or manually save the presentation so the updated values sync back to SharePoint.
Return to your web browser and refresh the page to see the updated presentation with the latest Excel values.
Try WPS Office for Seamless Presentation Management
If you frequently encounter limitations with web-based presentation tools, consider switching to WPS Office. It offers a fully-featured, lightweight desktop suite that handles linked data seamlessly and is highly compatible with Microsoft Office formats.
- 1. Download and Install WPS Office: Go to the official WPS website and download the free desktop application for your operating system.
- 2. Open Your Presentation: Launch WPS Presentation and open your .pptx file directly from your local drive or cloud storage.
- 3. Manage Your Linked Data: Easily update linked Excel charts and objects directly using WPS Office's robust desktop features without browser limitations.
Frequently Asked Questions
Why do linked Excel charts show outdated numbers in PowerPoint for the Web?
PowerPoint for the Web lacks the backend functionality to automatically query and refresh data from linked external files. It only displays the cached values saved from the last desktop application update.
Can I manually force an update of linked data directly in the web browser?
No, there is no button or menu option in PowerPoint for the Web to refresh linked external Excel objects. You must open the file in the desktop application to perform the update.
Will my linked data update if the Excel file is also saved on SharePoint?
Even if both the Excel source file and the PowerPoint presentation are hosted on SharePoint or OneDrive, the web version of PowerPoint still cannot process the data connection to refresh the links.
What happens if AutoSave is turned off in the desktop app?
If AutoSave is disabled and you do not manually save your changes, the refreshed data will not be uploaded back to SharePoint, meaning the web version will continue to show the old data when you refresh the browser.
