'%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 Link an Excel Online Table to a PowerPoint Presentation in a Browser
Question details
The user wants to connect or embed a table from an Excel Online workbook into a PowerPoint presentation while working directly in a web browser.
- Product
- Excel Online and PowerPoint for the Web
- Device & OS
- not provided
- Scenario
- Creating a presentation in a web browser and needing to display data from a web-based spreadsheet.
- Observed behavior
- Web versions of Excel and PowerPoint do not support the live-linking, embedded Excel object, or Paste Special features that are available in the desktop applications.
Ensure that your Excel Online workbook is saved to OneDrive or SharePoint and that you have appropriate sharing permissions enabled before attempting to link it.
Insert the Excel Link as a Hyperlink in PowerPoint for the Web
Since web applications lack live embedding capabilities, using a direct hyperlink is the best native workaround to connect your Excel data within the browser.
This method creates a clickable link in your presentation that opens the live Excel workbook in a new browser tab. While it does not visually embed the table on the slide, it guarantees access to the most up-to-date data during your presentation.
Open your workbook in Excel for the Web. Click the 'Share' button in the top right corner and select 'Copy Link' to generate a shareable URL.
Switch to your PowerPoint for the Web tab. Select the text, image, or shape on your slide that you want to act as the clickable button for your table.
Press 'Ctrl + K' (or navigate to Insert > Link). Paste the copied Excel link into the address bar and click 'Insert' or 'Apply'.
Use Desktop Applications for Live Data Linking
If you require a table that visually updates automatically within your slides, you must transition from the browser to the desktop versions of Excel and PowerPoint.
Experience Seamless Data Linking with WPS Office
Avoid the limitations of web-based document editing. WPS Office provides a complete, free desktop suite that easily handles advanced features like live-linking between spreadsheets and presentations without the restrictions of browser apps.
- 1. Install WPS Office: Download and install the free WPS Office desktop suite on your computer.
- 2. Copy your spreadsheet data: Open your document in WPS Spreadsheets, highlight your table, and copy it.
- 3. Paste link into your presentation: Open WPS Presentation, use the 'Paste Special' feature, and select 'Paste Link' to create a live-updating table.
Frequently Asked Questions
Can I use Paste Special to link data in Excel Online?
No, Excel for the Web and PowerPoint for the Web do not support the Paste Special feature for live-linking or embedding OLE objects. You must use desktop applications for this functionality.
Why can't I embed an Excel object in PowerPoint for the web?
Web browsers have security and architectural limitations that prevent Object Linking and Embedding (OLE), which is the underlying technology Microsoft Office uses to embed live Excel objects into PowerPoint slides.
Will hyperlinks to Excel update automatically in my presentation?
A hyperlink will always direct you to the latest version of the Excel file when clicked, ensuring you see the most current data. However, it will not display the updated data visually on the PowerPoint slide itself.
How do I make my Excel table update visually in my presentation?
To have the table update visually on the slide, you must open both files in desktop applications (like Microsoft Office or WPS Office) and use the 'Paste Special' > 'Paste Link' feature.
