Office Settings & Configuration

How to Disable Automatic Updates for All Excel Links in PowerPoint

Huda QurayshiHuda Qurayshi Oct 21, 2026 872 views

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.

How to Disable Automatic Updates for All Excel Links in PowerPoint
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 you start

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.

Solution 1Recommended

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.

1
Open the VBA Editor

While your PowerPoint presentation is open, press 'ALT + F11' on your keyboard to launch the Microsoft Visual Basic for Applications window.

2
Insert a New Module

In the VBA editor, click 'Insert' from the top menu bar, then select 'Module' to create a blank scripting window.

3
Paste the Macro Code

Input a standard VBA script designed to loop through all shapes (e.g., ActivePresentation.Slides) and change Shape.LinkFormat.AutoUpdate to ppUpdateOptionManual.

4
Run the Macro

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.

Use a VBA Macro to Disable All Linked Objects at Once
Enable Macros: You may need to enable macros in PowerPoint's Trust Center settings for the script to run successfully. Always test VBA scripts on a duplicate file first.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website to download the free office suite for your operating system.
  2. 2. Open Your Presentation: Launch WPS Presentation and open your existing PPTX file containing the linked Excel objects.
  3. 3. Manage Presentation Data: Use the familiar interface tools within WPS Presentation to review, update, or edit your connected spreadsheets seamlessly.
Fully compatible with Microsoft PowerPoint (.pptx) and Excel (.xlsx) formats.Insert, edit, and manage linked spreadsheet data seamlessly.Free to use with a lightweight, modern tabbed interface.Built-in robust tools for seamless presentation handling.
microsoft office alternative - wps office

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.