'%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 Excel Links Not Updating in OneDrive or Teams
Question details
The user needs to ensure that Excel data linked to a PowerPoint presentation updates correctly when the presentation is viewed in a browser or distributed via automated workflows.
- Product
- Microsoft PowerPoint, Excel, OneDrive, Power Automate
- Device & OS
- not provided
- Scenario
- Viewing or sharing a PowerPoint presentation containing dynamically linked Excel dashboard data via cloud services (Teams/OneDrive) or Power Automate.
- Observed behavior
- The linked data updates properly on the desktop application but fails to update or converts to a static copy when opened in a browser view or when delivered as an email attachment through Power Automate.
Ensure both your Excel spreadsheet and PowerPoint presentation are saved in the same cloud directory (such as OneDrive or SharePoint) before attempting to repair or test the linked data.
Share the Presentation via OneDrive Link
Sharing the file as a link rather than a physical attachment ensures the linked Excel data remains dynamic and updates correctly for the recipient.
When a PowerPoint file is sent as an email attachment, a static copy is created. This severs the connection to the original Excel file, preventing any future updates from displaying. To preserve dynamic links, both files must reside in the cloud and be shared via links.
Upload your source Excel dashboard and the destination PowerPoint presentation to the exact same folder in your OneDrive or SharePoint.
Open the PowerPoint file in the desktop app. Go to File > Info > Edit Links to Files, and ensure the source path points to the cloud URL (OneDrive) of the Excel file rather than a local hard drive path.
Instead of attaching the file to an email, click the 'Share' button in OneDrive or PowerPoint. Copy the sharing link and send it to your recipient so they view the live, connected document.
Adjust Power Automate Settings for Linked Files
Modify your Power Automate workflow to send a sharing link instead of retrieving and attaching the physical file.
Try WPS Office for Seamless File Sharing and Linking
If you are tired of complex syncing issues and broken links across different cloud platforms, WPS Office offers a lightweight, highly compatible alternative. Enjoy seamless linking between spreadsheets and presentations without the hassle of complicated automated workflows.
- 1. Download and Install: Visit the official WPS website to download and install WPS Office for free.
- 2. Open Your Files: Open your existing Microsoft PowerPoint and Excel files directly in WPS Office without losing any formatting.
- 3. Link Data Seamlessly: Copy your data from WPS Spreadsheet and use 'Paste Special' in WPS Presentation to create reliable dynamic links.
Frequently Asked Questions
Why do my Excel links work on the desktop but not in the browser view?
Desktop applications have direct access to your local or synced file paths to refresh data instantly. Browser versions (like Teams or Excel for Web) operate in a restricted environment and often lack the ability to pull real-time data from external files due to security policies, requiring both files to be properly hosted and linked via exact cloud URLs.
Does sending a PowerPoint as an email attachment break Excel links?
Yes. When you attach a file to an email, it creates a static, isolated copy of the presentation. It loses the connection to the original Excel file on your drive, preventing any future updates from reflecting in the slides.
How can I ensure linked Excel data updates automatically in PowerPoint?
To maintain automatic updates, always store both the Excel and PowerPoint files in a shared cloud environment like OneDrive or SharePoint. In PowerPoint, navigate to File > Info > Edit Links to Files, and set the link to update automatically using the cloud path rather than a local 'C:' drive path.
