How to Disable Automatic Updates for All Excel Links in PowerPoint
Question details
The user wants to find a way to disable automatic updates for multiple linked Excel objects in a PowerPoint presentation simultaneously, rather than changing each link individually.

- Product
- Microsoft PowerPoint
- Device & OS
- not provided
- Scenario
- Managing a presentation containing multiple linked Excel spreadsheets and attempting to stop them all from updating automatically upon opening or modifying the file.
- Observed behavior
- PowerPoint lacks a native one-click option to bulk disable link updates, requiring users to either change link update settings individually or seek a macro-based workaround.
Before running any macro scripts or making bulk changes to your presentation links, always save a backup copy of your file to prevent accidental data loss or link corruption.
Use a VBA Macro to Disable All Linked Objects at Once
Since PowerPoint does not have a native bulk-disable button, running a Visual Basic for Applications (VBA) macro is the most effective way to change all links to manual update mode instantly.
PowerPoint handles linked objects individually by design. To bypass this limitation, you can execute a short VBA script that loops through all slides and shapes, finding linked OLE objects and setting their update property to manual.
You can find scripts for this process on the Microsoft Answers forum. Be sure to review any code before executing it.
While your PowerPoint presentation is open, press 'ALT + F11' on your keyboard to launch the Microsoft Visual Basic for Applications window.
In the VBA editor, click 'Insert' from the top menu bar, then select 'Module' to create a blank scripting window.
Input a standard VBA script designed to loop through all shapes (e.g., ActivePresentation.Slides) and change Shape.LinkFormat.AutoUpdate to ppUpdateOptionManual.
Press 'F5' or click the 'Run' button (the green play icon) on the toolbar to execute the script and update all Excel links in the file.

Manually Change Link Settings via the File Menu
If you prefer not to use macros, you can change the update settings manually through the PowerPoint document links interface, where you can select multiple items at once.
Try WPS Presentation for Better File Management
Managing linked spreadsheets and complex presentations can sometimes be challenging. WPS Office offers a free, lightweight alternative to Microsoft Office, featuring high compatibility with PPTX files and an intuitive interface.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free office suite for your operating system.
- 2. Open Your Presentation: Launch WPS Presentation and open your existing PPTX file containing the linked Excel objects.
- 3. Manage Presentation Data: Use the familiar interface tools within WPS Presentation to review, update, or edit your connected spreadsheets seamlessly.

Frequently Asked Questions
Why do Excel links in PowerPoint update automatically?
By default, PowerPoint sets newly pasted OLE links to update automatically so your presentation always reflects the latest spreadsheet data upon opening.
Will breaking the link keep my Excel data visible on the slide?
Yes. If you break the link, the Excel object becomes a static picture or a standalone embedded object. It will no longer update, but the current visible data will remain intact on the slide.
Can I manage link updates without using a VBA macro?
Yes, you can manage updates manually by navigating to File > Info > Edit Links to Files, where you can multi-select links and set them to manual update without using code.




