Fix Missing Linked Excel Tables in PowerPoint
Question details
The user needs linked Excel tables and ranges to remain visible in PowerPoint after the presentation is reopened.

- Product
- Microsoft PowerPoint, Microsoft Excel, and OneDrive
- Device & OS
- not provided
- Scenario
- A presentation contains charts and ranges linked to an Excel workbook, with both files stored in OneDrive.
- Observed behavior
- Linked tables or ranges disappear after the presentation is reopened, although linked charts may continue to update.
Identify the source workbook and presentation, and check whether they were created in OneDrive or synchronized from another location. Choose a local test folder outside OneDrive; the Desktop may itself be synchronized.
Test the Excel and PowerPoint files outside OneDrive
Use local copies to check whether the missing tables are associated with OneDrive storage or synchronization.
In Excel and PowerPoint, use File > Save As to save copies of the workbook and presentation in a local folder that is not synchronized with OneDrive.
Open the local presentation and look under File > Info for Edit Links to Files, if available. Check whether the linked source points to the local workbook copy; use Change Source to select it when possible.
Save and close both local files, then reopen the presentation. Update the links if prompted and check whether the tables remain visible and reflect changes made in the local workbook.
In PowerPoint, open File > Account and review the product information and version. Record the version and whether the files were originally created in OneDrive or synchronized from elsewhere.

Recreate the linked table in a local presentation
Try rebuilding the link if the existing presentation remains unreliable during the local test.
Work with Excel and PowerPoint files in WPS Office
WPS Office is a free, lightweight Office alternative with a familiar interface for working with spreadsheets and presentations. Its Microsoft Office format compatibility helps you move existing files into WPS, though it does not repair Microsoft Office or guarantee identical behavior for linked objects.

Frequently Asked Questions
Why do my linked charts update while linked tables disappear?
Charts and pasted ranges can use different linked objects, so one may work while another fails. Test both in a local presentation and check the source under File > Info > Edit Links to Files, if that option is available.
How can I tell whether OneDrive is involved?
Save copies of both files in a folder outside OneDrive, point the presentation links to the local workbook if possible, and reopen the presentation. Compare the result with the OneDrive copies.
Is my Desktop always a local location outside OneDrive?
No. The Desktop may be synchronized with OneDrive. Check its location before using it for the test, or select another local folder that is not synchronized.
How do I create a new linked Excel range in PowerPoint?
Copy the range in Excel, then in PowerPoint choose Home > Paste > Paste Special. Select Paste Link and an available Microsoft Excel worksheet object option, then save and reopen the presentation to test it.
Where can I find my Office version?
In PowerPoint, open File > Account and look at the product information and version. Include that information if you seek further support.




