'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Update Excel Links in PowerPoint for Mac
Question details
The user is unable to update or create linked Excel objects (such as chart templates) within a PowerPoint presentation on a Mac.
- Product
- PowerPoint for Mac
- Device & OS
- Mac
- Scenario
- Attempting to relink a chart template to a new Excel workbook or update an existing Excel link in a presentation.
- Observed behavior
- PowerPoint for Mac does not support creating or updating OLE linked Excel objects, preventing the data from being dynamically refreshed or relinked to new source files.
Before proceeding, confirm you are using PowerPoint for Mac. Keep in mind that Mac Office applications do not have the 'File' tab found in Windows, which changes how linked objects are managed.
Embed the Excel Workbook and Update Manually
Since OLE linking is not supported on macOS, embedding the Excel workbook directly into your presentation allows you to retain and manually update your data.
Embedding an object means the data becomes part of the PowerPoint file itself rather than linking to an external file. While it won't update automatically when the external file changes, it ensures your charts and data remain accessible and editable on a Mac.
Open your source Excel workbook on your Mac, select the chart or data range you need, and press Cmd + C to copy it.
Open your PowerPoint presentation, click on the slide where you want the data, navigate to the Edit menu at the top, and select Paste Special.
In the Paste Special dialog box, select 'Microsoft Excel Workbook Object' and click OK to embed the data.
Whenever you need to change the chart or figures, simply double-click the embedded object in PowerPoint to open it in an embedded Excel window and manually update the values.
Update Linked Objects via PowerPoint for Windows
If maintaining a dynamic OLE link to an external Excel file is strictly required, you must use the Windows version of PowerPoint to update or relink the objects.
Try WPS Office for Seamless Presentation and Spreadsheet Management
Since PowerPoint for Mac lacks full OLE support for dynamic Excel links, consider using WPS Office. As a lightweight, highly compatible, and free alternative to Microsoft Office, WPS Presentation and WPS Spreadsheet make it incredibly easy to manage charts, embed data, and build professional slides without platform-specific restrictions.
- 1. Download WPS Office: Visit the official WPS Office website and download the free installer for Mac.
- 2. Install the application: Run the downloaded installer and move the WPS Office app into your Applications folder.
- 3. Open your presentation: Launch WPS Presentation, open your existing PowerPoint file, and manage your embedded charts with ease.
Frequently Asked Questions
Why is the 'File' tab missing in PowerPoint for Mac?
The 'File' tab on the ribbon is specific to the Windows and web versions of Microsoft Office. On a Mac, file-level commands like Save, Print, and Info are located in the standard Apple menu bar at the very top of your screen.
Does PowerPoint for Mac support OLE links for Excel files?
No. While PowerPoint for Mac allows you to embed Excel objects natively, it does not support creating or dynamically updating Object Linking and Embedding (OLE) links to external Excel files.
Can I convert an OLE link to an embedded object on Mac?
If a presentation containing OLE links is opened on a Mac, you cannot automatically convert the dynamic link to an embedded object. You will need to manually copy the data from the source Excel file and use 'Paste Special' to embed it into the presentation.
