VBA & Macro Problems

How to Update PowerPoint Slides from an Excel Spreadsheet via VBA

Steve K Sep 25, 2026 868 views

Question details

The user needs to automatically populate names and values across multiple PowerPoint slides, such as diplomas and name cards, using structured data from an Excel spreadsheet.

How to Update PowerPoint Slides from an Excel Spreadsheet

Product: Microsoft Office (Excel and PowerPoint)
Device & OS: not provided
Scenario: Generating customized PowerPoint presentations by matching Excel table data to specific presentation slide layouts.
Observed behavior: Excel worksheet rows must map to individual PowerPoint slides, and Excel columns must map sequentially to text boxes on those slides.

Before you start

Ensure your target PowerPoint presentation is created with a consistent slide layout and that the text boxes are placed in the exact order you wish to populate them.

Solution 1Recommended

Use a VBA Script to Map Excel Data to PowerPoint Slides

Use a cross-application VBA macro in Excel to map spreadsheet rows to slides and columns to specific text boxes in your PowerPoint file.

By utilizing Visual Basic for Applications (VBA), you can bridge Excel and PowerPoint. The script iterates through your Excel spreadsheet, creating a new slide for each row and populating the slide's text boxes with the data from the columns.

Prepare the PowerPoint Layout

Open PowerPoint and design your slides (e.g., diploma template). Ensure all dynamic text boxes are created in the specific order that corresponds to your Excel columns.

Format Your Excel Data

Organize your Excel worksheet so each row represents a new slide. If a specific value (like a Name) needs to appear twice on the same slide, duplicate that column in Excel.

Open the VBA Editor

In Excel, press Alt+F11 to launch the VBA Editor. Go to Insert > Module, and paste your Excel-to-PowerPoint integration script.

Update the Presentation File Path

Review the pasted VBA code, locate the file path string, and modify it to exactly match the location of your target PowerPoint file on your local drive.

Run the Macro

Close the VBA editor, press Alt+F8 in Excel to open the Macro dialog box, select your newly added script, and click Run to automatically generate and update the PowerPoint slides.

Use a VBA Script to Map Excel Data to PowerPoint Slides

Handling Excluded Data: Any data placed in excluded or unmapped columns in your Excel spreadsheet will be ignored by the VBA script and will not be transferred to the presentation.

Free Microsoft Office alternative

Try WPS Office for Seamless Spreadsheet and Presentation Management

If cross-application VBA macros feel too complex, WPS Office provides a free, highly compatible, and user-friendly alternative to Microsoft Office. It seamlessly handles both spreadsheets and presentations with a familiar interface, ensuring efficient daily workflows without the heavy resource usage.

1. Download the Software: Visit the official WPS Office website and click download to get the free version for your device.
2. Open Your Files: Launch WPS Office and open your existing .xlsx and .pptx files; formatting and data remain perfectly preserved.
3. Edit and Export: Use WPS Spreadsheets and WPS Presentation to manage your data intuitively, then save or export to PDF seamlessly.

Fully compatible with Microsoft Excel (.xlsx) and PowerPoint (.pptx) file formats.Manage spreadsheets, presentations, and documents together in an all-in-one tabbed workspace.Familiar and intuitive user interface ensures a zero learning curve and simple migration.Lightweight application that uses minimal system resources and operates smoothly.

microsoft office alternative - wps office

Frequently Asked Questions

How do I display the same name multiple times on a single PowerPoint slide?

To show the exact same data in multiple text boxes on one slide, simply duplicate that data column in your Excel spreadsheet so the VBA script maps it to a secondary text box.

What happens if my Excel spreadsheet has columns I don't want in PowerPoint?

Any columns in Excel that are not explicitly targeted or mapped by your VBA script will simply be ignored. The data in these excluded columns will not be transferred to the PowerPoint slides.

How should I handle static, unchangeable text on the slides?

It is best to place unchangeable text in the PowerPoint Slide Master, or position them in later text boxes that the Excel script is programmed to skip over.

Excel & Data Problems