How to Show a New Excel Column in a Linked PowerPoint Table
Question details
The user needs to display a newly added column from an Excel spreadsheet inside a linked PowerPoint table that currently fails to update.

- Product
- PowerPoint and Excel
- Device & OS
- not provided
- Scenario
- Updating linked data between an Excel workbook and a PowerPoint presentation after structurally modifying the source data.
- Observed behavior
- The newly added column in the source Excel file does not automatically appear in the linked PowerPoint table or worksheet object.
Ensure both the Excel source file and the PowerPoint presentation are saved on your local drive, and verify that the Excel file is not currently open in a restrictive read-only mode.
Manually Update the Linked Table in PowerPoint
Force PowerPoint to refresh its data connection with the source Excel file to pull in the newly added columns.
PowerPoint does not always fetch updates in real-time if the presentation was open while the Excel file was modified. Manually triggering the update usually synchronizes the view.
Open the PowerPoint presentation containing the linked Excel table and navigate to the relevant slide.
Right-click directly on the linked table or worksheet object.
Select 'Update Link' from the context menu and wait a moment for the application to pull the latest data from the Excel file.

Expand the Named Range in the Source Excel File
If the link relies on a specific named range instead of the entire worksheet, the new column might be outside of that defined range.
Reinsert the Table Using Paste Special
If updating the link fails or the structure is corrupted, establishing a fresh connection by re-linking the table often resolves the issue.
Link Data Seamlessly with WPS Office
WPS Office provides excellent compatibility for linking spreadsheet data into your presentations. You can easily insert, update, and manage dynamic data without layout issues.
- 1. Copy the data: Open your spreadsheet in WPS Spreadsheets, select the desired data range including any new columns, and copy it.
- 2. Navigate to Paste Special: Switch to WPS Presentation, select the target slide, click the 'Home' tab, expand the 'Paste' menu, and choose 'Paste Special'.
- 3. Establish the link: Select 'Paste link', choose 'WPS Spreadsheets Object', and click 'OK' to display your dynamic table.

Frequently Asked Questions
Why does 'Update Link' not pull my new Excel data into PowerPoint?
This usually happens if the linked object was originally restricted to a specific named range that hasn't been updated, or if the source file's location has changed. Verify the file path under File > Info > Edit Links to Files.
How do I edit the Excel source file directly from PowerPoint?
You can generally double-click the linked table or object in your PowerPoint slide. This action will automatically launch the associated spreadsheet application and open the exact source file for immediate editing.
Does breaking the link in PowerPoint delete the original Excel file?
No, breaking the link simply converts the linked object into a standard PowerPoint table or a static picture on the slide. Your original Excel file remains completely untouched and safe on your drive.
Can I link only specific cells instead of the whole worksheet?
Yes, you can highlight only the specific cells you want in Excel, copy them, and then use Paste Special > Paste Link in PowerPoint. Only that exact selected data range will be displayed dynamically on the slide.




