How to Stop PowerPoint Security Warnings for Linked Excel Data
Question details
The user needs to disable security warnings and update prompts for linked Excel data in PowerPoint to allow the presentation to play automatically without interruption.
- Product
- Microsoft PowerPoint
- Device & OS
- not provided
- Scenario
- Setting up an automated, unattended PowerPoint slideshow that pulls live or linked data from an XLSM Excel workbook.
- Observed behavior
- Upon opening, PowerPoint displays a security prompt asking whether to update the linked Excel data, which halts the automatic playback until manually clicked.
Ensure that your linked Excel workbook (XLSM) is saved in its final directory, as moving the source file later will break the links regardless of your security settings.
Set Linked Excel Files to Update Manually
Disabling automatic updates prevents PowerPoint from asking for permission to fetch new data upon opening, allowing unattended playback.
By default, PowerPoint attempts to refresh external data automatically when you open a file. Changing the link behavior to manual ensures the slideshow opens immediately without halting for a prompt.
Open your PowerPoint presentation and navigate to File > Info in the top ribbon.
Look at the bottom right under 'Related Documents' and click on 'Edit Links to Files'.
Select the linked Excel files from the list and uncheck the 'Automatic Update' option.
Close the links dialog and save your presentation.
Add Presentation Directory to Trusted Locations
Adding the folder to PowerPoint's Trust Center can bypass security warnings for macro-enabled (XLSM) links.
Seamlessly Manage Linked Data with WPS Presentation
WPS Office offers an intuitive way to manage external data links in your slides without disruptive security pop-ups, ensuring your unattended slideshows run perfectly.
- 1. Open your file: Open your presentation containing the linked charts or tables in WPS Presentation.
- 2. Navigate to the Data tab: Click on the Data tab located on the top ribbon.
- 3. Edit Links: Click on 'Edit Links' to view all connected external Excel data.
- 4. Modify update settings: Choose to set updates to manual, or click 'Break Link' to finalize the data for interruption-free display.
Frequently Asked Questions
Why does PowerPoint ask to update links every time I open the file?
PowerPoint is designed to protect you from potentially malicious external scripts or data changes. When a file contains external OLE links, it prompts you to confirm you trust the source before fetching new data.
What happens if I move the Excel file to a different folder?
The links in your PowerPoint presentation will break because they rely on absolute file paths. You will need to go to File > Info > Edit Links to Files and use the 'Change Source' option to re-link the Excel workbook to its new location.
Why do I still get warnings after adding the folder to Trusted Locations?
This usually happens if the linked Excel file requires macro execution (XLSM) or is stored in a location not trusted by Excel itself. Ensure the file's location is also added to Microsoft Excel's Trusted Locations, not just PowerPoint's.
