SharePoint Document Issues

Fix Missing SharePoint Check-Out After OneDrive Sync

Ayan MasoodAyan Masood Nov 14, 2026 868 views

Question details

The user needs to check out an Excel file in a Teams-linked SharePoint library and use it as a Word mail merge data source.

Fix Missing SharePoint Check-Out After OneDrive Sync
Product
SharePoint, Microsoft Teams, OneDrive, Excel, and Word
Device & OS
not provided
Scenario
A SharePoint library connected to a Teams channel was synchronized with OneDrive for a Word mail merge.
Observed behavior
Check-in and check-out controls are unavailable, and the synchronized Excel file appears read-only.
Before you start

Identify the SharePoint library and Excel file used for the mail merge. Confirm that you have edit access to the library; an administrator may be needed to review its settings.

Solution 1Recommended

Manage check-out from the SharePoint library

Use SharePoint when the Document Library tab in Teams does not show check-in or check-out controls.

1
Open the library in SharePoint

In the Teams channel, open the Document Library tab and select Open in SharePoint.

2
Check out the Excel file

In the SharePoint library, select the Excel file, open its More options menu, and choose More > Check out.

3
Check the file back in

After editing, return to the file's More options menu in SharePoint and choose More > Check in. Add a comment if prompted.

Manage check-out from the SharePoint library
Check-out controls in Teams: The Document Library tab in Teams may not expose check-out controls. Synchronizing a library with OneDrive does not replace SharePoint's check-out and versioning settings.
Free Microsoft Office alternative

Work with Word and Excel files in WPS Office

WPS Office is a free, lightweight alternative with a familiar interface for working with documents and spreadsheets. Its Microsoft Office format compatibility helps you move existing files into WPS, though it does not fix SharePoint permissions or OneDrive sync settings.

Open and edit compatible Word and Excel files, including DOCX and XLSX.Work with spreadsheet recipient data and document content in one office suite.Use a familiar interface that makes switching from Microsoft Office easier.Download a free, lightweight office suite.
microsoft office alternative - wps office

Frequently Asked Questions

Why is check-out missing from my Teams library tab?

A Document Library tab in Teams may not expose check-out controls. Select Open in SharePoint, then use the Excel file's More options menu to check it out.

Does OneDrive sync automatically make SharePoint files read-only?

No. Read-only access can depend on permissions, required metadata, library policies, or sync restrictions. Check Manage access in SharePoint and review any errors shown by the OneDrive cloud icon.

Where can I see whether the library requires check-out?

Open the library in SharePoint and go to Settings > Library settings > Versioning settings. If you cannot access the setting, ask a library administrator.

Can Word use a synced Excel file for mail merge?

In desktop Word, try Mailings > Select Recipients > Use an Existing List and browse to the accessible OneDrive-synced workbook. If it cannot be opened, download a working copy from SharePoint and select that copy instead.

Will a downloaded Excel data source stay synchronized with SharePoint?

No. A file downloaded using SharePoint's Download command is a separate copy. Download it again or update it if the original recipient data changes.