Open and Edit an Embedded PowerPoint Presentation in Excel
Question details
The user wants to open an embedded PowerPoint presentation in Excel directly for editing instead of having it launch in presentation mode first.
- Product
- Microsoft Excel with embedded Microsoft PowerPoint objects
- Device & OS
- not provided
- Scenario
- A workbook contains one or more embedded PowerPoint presentations that need to be updated repeatedly.
- Observed behavior
- Selecting the embedded presentation may open it in presentation mode, requiring the user to close it and choose Presentation Object > Modify to edit the slides.
Confirm that the workbook is open in the desktop version of Excel and that PowerPoint is installed on the same computer. If you use a macro, enable macros only in workbooks from a trusted source.
Use Presentation Object > Modify to edit the embedded presentation
Use this method when you need to edit an embedded PowerPoint object occasionally and do not need automation.
In the Excel worksheet, click the embedded PowerPoint object once to select its border.
Right-click the selected object, point to Presentation Object, and select Modify.
Make changes in the PowerPoint editing window, then save the presentation and close the editing window to return to Excel.
Run a VBA macro to activate the embedded PowerPoint object for editing
Use this method when you frequently edit the same embedded presentation and want to avoid selecting Modify manually each time.
Replace embedded presentations with OneDrive or SharePoint links
Use linked PowerPoint files when multiple people need to edit the workbook and presentations collaboratively.
Create and manage linked Excel and PowerPoint files with WPS Office
If embedded Microsoft Office objects are limiting editing or collaboration, WPS Office provides a free, lightweight alternative for working with spreadsheets and presentations as separate, easy-to-share files. Its familiar interface helps you move from Excel and PowerPoint while keeping common document formats compatible.
- 1. Open the workbook in WPS Spreadsheets: Launch WPS Office, choose Spreadsheets, and open the Excel .xlsx workbook.
- 2. Open or save the presentation separately: Choose Presentation in WPS Office and open the related .pptx file, or save it as a separate presentation file.
- 3. Create a workbook link: In WPS Spreadsheets, select a cell or shape, choose Insert > Hyperlink, and select or paste the path to the presentation file.
- 4. Edit the presentation directly: Click the hyperlink to open the presentation in WPS Presentation, edit the slides, and save the .pptx file.
Frequently Asked Questions
Why does an embedded PowerPoint file open as a slideshow from Excel?
The embedded OLE object's default action may be set to Open or Play. To force editing, right-click the object in Excel and choose Presentation Object > Modify.
Can I make an embedded PowerPoint presentation editable with one click in Excel?
You can automate the action with a VBA macro that calls the OLE object's open verb, then assign the macro to a worksheet shape or button. The exact OLE object name must match the object in your workbook.
Where can I find the name of an embedded PowerPoint object in Excel?
Click the embedded object and check the Name Box beside the formula bar. You can also open Alt+F11 and inspect the worksheet's OLEObjects collection in the Visual Basic Editor.
Does embedding PowerPoint files affect Excel AutoSave or co-authoring?
It can. Embedded OLE objects may restrict AutoSave or collaborative editing in some Microsoft 365 workbook scenarios. Storing the PowerPoint file separately in OneDrive or SharePoint and linking to it is usually better for collaboration.
How do I link an Excel workbook to a PowerPoint presentation instead of embedding it?
Save the presentation as a separate .pptx file in OneDrive, SharePoint, or another accessible location. In Excel, select a cell or shape, choose Insert > Link, and add the presentation file link.
