How to Automatically Update Excel Data in a PowerPoint PPSX Slideshow
Question details
The user needs a method to automatically refresh linked Excel data within a running PowerPoint PPSX slideshow without manual intervention.

- 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.
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.
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.
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'.
In PowerPoint, press ALT + F11 to open the Visual Basic for Applications (VBA) editor. Go to Insert > Module to create a new module.
Paste the following code into the module window: Sub OnSlideShowPageChange(ByVal Wn As SlideShowWindow) ActivePresentation.UpdateLinks End Sub.
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.

Configure Link Updates on Presentation Open (No VBA)
If VBA macros are restricted in your environment, you can set PowerPoint to update linked data automatically every time the file is opened.
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. Copy Source Data: Open your source spreadsheet in WPS Spreadsheet and copy the target data range.
- 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. Enable Macros: Navigate to the Developer tab, open the VBA Editor, and insert your UpdateLinks script.
- 4. Save and Run: Save your document in a macro-enabled format and launch your slideshow to see the data update in real-time.

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.




