'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
Fix PowerPoint Charts Not Updating from Excel Files in SharePoint
Question details
Users are experiencing issues where PowerPoint charts linked to Excel workbooks hosted on SharePoint fail to update or refresh data reliably.
- Product
- Microsoft PowerPoint, Excel, SharePoint
- Device & OS
- not provided
- Scenario
- Updating linked chart data in a PowerPoint presentation when the source Excel file is located on SharePoint.
- Observed behavior
- Linked charts do not refresh with new data in PowerPoint, despite the same links functioning correctly when the files are stored on a local drive.
Ensure you are signed into the correct Microsoft 365 account with active permissions to access both the PowerPoint presentation and the source Excel workbook on SharePoint.
Verify Permissions and Open in Desktop Apps
Ensuring proper access rights and forcing a local sync via desktop applications can often resolve SharePoint link issues.
Navigate to the SharePoint folder containing both the Excel source file and the PowerPoint presentation to verify you have 'Edit' access to both.
Instead of using the web versions, open both the Excel workbook and the PowerPoint presentation simultaneously using the desktop versions of Office.
In PowerPoint, select the chart, go to the 'Chart Design' tab, and click 'Refresh Data' to see if the link re-establishes.
Submit a Support Ticket via Microsoft 365 Admin Center
If local troubleshooting fails and data remains unchanged despite a successful refresh prompt, the issue requires Microsoft support intervention.
Switch to WPS Office for Reliable File Management
Tired of complicated syncing issues? WPS Office is a highly compatible, lightweight, and free alternative to Microsoft Office. It offers seamless integration for presentations, spreadsheets, and documents with stable built-in cloud support.
- 1. Download the Installer: Visit the official WPS Office website and click the free download button.
- 2. Install WPS Office: Run the downloaded setup file and follow the on-screen instructions to install the suite.
- 3. Open Your Files: Launch WPS Presentation and easily open your existing .pptx files to continue working without hassle.
Frequently Asked Questions
Why do linked PowerPoint charts work locally but not on SharePoint?
Local files use direct system file paths (like C:\Documents\file.xlsx), which are highly stable. SharePoint uses web URLs that require active authentication, stable network connections, and sync clients, which can sometimes fail to pass data correctly between Excel and PowerPoint.
How do I manage or edit the links to my Excel data in PowerPoint?
In PowerPoint, go to the 'File' menu, select 'Info', and look for 'Related Documents' in the bottom right corner. Click on 'Edit Links to Files' to view, update, change the source, or break the links to your Excel workbooks.
Can I break the link and just keep the chart data in PowerPoint?
Yes. You can break the link so the chart relies only on the data currently embedded in the presentation. Go to File > Info > Edit Links to Files, select the specific Excel link, and choose 'Break Link'.
How do I force a linked chart to update automatically when I open the presentation?
You can go to File > Info > Edit Links to Files, and set the update method for the specific chart link from 'Manual' to 'Automatic'. This prompts PowerPoint to fetch the latest Excel data as soon as the file is opened.
