OneDrive File Issues

Fix Missing Linked Excel Tables in PowerPoint

Amos GikundaAmos Gikunda Nov 20, 2026 868 views

Question details

The user needs linked Excel tables and ranges to remain visible in PowerPoint after the presentation is reopened.

Fix Missing Linked Excel Tables in PowerPoint
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.
Before you start

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.

Solution 1Recommended

Test the Excel and PowerPoint files outside OneDrive

Use local copies to check whether the missing tables are associated with OneDrive storage or synchronization.

1
Save local copies

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.

2
Check the source link

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.

3
Reopen and test

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.

4
Check the Office version

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.

Test the Excel and PowerPoint files outside OneDrive
Compare the results: If the local links work but the OneDrive copies do not, storage or synchronization may be involved. If the links still fail locally, try recreating the affected presentation.
Free Microsoft Office alternative

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.

Open and edit presentations and spreadsheets in one suiteCompatible with Microsoft PowerPoint PPTX and Excel XLSX formatsUse a familiar interface to work with tables and slidesMove existing Office files into a lightweight, free application
QA img-9

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.