VBA & Macro Problems

How to Automatically Update Excel Data in a PowerPoint PPSX Slideshow

Tauseeq MagsiTauseeq Magsi Nov 4, 2026 870 views

Question details

The user needs a method to automatically refresh linked Excel data within a running PowerPoint PPSX slideshow without manual intervention.

How to Automatically Update Excel Data in a PowerPoint PPSX Slideshow
Product
PowerPoint and Excel
Device & OS
not provided
Scenario
Running a self-advancing kiosk presentation (PPSX) that contains live or frequently changing Excel data, such as a daily countdown or live dashboard.
Observed behavior
By default, linked Excel data requires manual updating or requires the presentation to be closed and reopened to refresh. A VBA solution is needed to update the data automatically while the slideshow is actively running.
Before you start

Ensure that both your PowerPoint presentation and the source Excel workbook are saved in a stable, accessible folder (preferably the exact same directory) before setting up data links.

Solution 1Recommended

Use a VBA Macro to Automatically Update Linked Excel Data

This is the most reliable method to ensure your PowerPoint slideshow automatically refreshes Excel data while continuously running in kiosk mode.

PowerPoint only updates linked OLE objects when the presentation is initially opened. To force updates during a slideshow, you can utilize a built-in event handler macro that triggers every time the slide changes.

1
Link the Excel Data

Open your Excel workbook, select the data range, and copy it. In PowerPoint, go to the Home tab, click the arrow below 'Paste', select 'Paste Special', choose 'Paste link', and select 'Microsoft Excel Worksheet Object'.

2
Open the VBA Editor

In PowerPoint, press ALT + F11 to open the Visual Basic for Applications (VBA) editor. Go to Insert > Module to create a new module.

3
Insert the Update Macro

Paste the following code into the module window: Sub OnSlideShowPageChange(ByVal Wn As SlideShowWindow) ActivePresentation.UpdateLinks End Sub.

4
Save as a Macro-Enabled Show

Close the VBA editor. Go to File > Save As, and choose 'PowerPoint Macro-Enabled Show (*.ppsm)' or 'PowerPoint Macro-Enabled Presentation (*.pptm)' to ensure the macro is retained and executed.

Use a VBA Macro to Automatically Update Linked Excel Data
Macro Security: Ensure macros are enabled on the kiosk computer where the slideshow will run, and add the folder to Trusted Locations so the VBA script is not blocked from executing.
Powerful Presentation Tool

Create and Automate Linked Presentations with WPS Office

WPS Office provides seamless integration between its Spreadsheet and Presentation applications, fully supporting OLE linking and VBA macros to build automated kiosk displays effortlessly.

  1. 1. Copy Source Data: Open your source spreadsheet in WPS Spreadsheet and copy the target data range.
  2. 2. Paste Special as Link: Switch to WPS Presentation, click the 'Paste' drop-down on the Home tab, select 'Paste Special', and choose 'Paste link'.
  3. 3. Enable Macros: Navigate to the Developer tab, open the VBA Editor, and insert your UpdateLinks script.
  4. 4. Save and Run: Save your document in a macro-enabled format and launch your slideshow to see the data update in real-time.
Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx, .ppsx, .pptm) formats.Built-in VBA editor to automate cross-application data updates effortlessly.Lightweight, fast, and completely free Office suite for creating dynamic kiosk presentations.
microsoft office alternative - wps office

Frequently Asked Questions

Why doesn't my linked Excel data update automatically during the continuous slideshow?

By default, PowerPoint only updates linked OLE objects when the presentation file is first opened. To update data while a slideshow is actively and continuously running, you must use a VBA macro triggered by slide changes.

Does the Excel file need to be kept open for the PowerPoint links to update?

No, the Excel file does not need to be actively open. However, it must remain in the exact same file path where it was originally linked. If you move, rename, or delete the Excel file, the data links in PowerPoint will break.

Can I save this automated presentation as a standard .pptx or .ppsx file?

If you are using the VBA macro to update links during the slideshow, you cannot save it as a standard .pptx or .ppsx. You must save it as a Macro-Enabled Presentation (.pptm) or Macro-Enabled Show (.ppsm) so the code is saved and allowed to run.

How do I prevent the security prompt when updating links in an unattended kiosk?

To prevent security prompts from interrupting an unattended kiosk display, you can add the folder containing your presentation and Excel files to the Trusted Locations list inside your Office Trust Center settings.