Fix Missing SharePoint Check-Out After OneDrive Sync
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.

- 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.
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.
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.
In the Teams channel, open the Document Library tab and select Open in SharePoint.
In the SharePoint library, select the Excel file, open its More options menu, and choose More > Check out.
After editing, return to the file's More options menu in SharePoint and choose More > Check in. Add a comment if prompted.

Investigate why the synchronized library is read-only
Check permissions and library requirements if the Excel file cannot be edited or synchronized.
Use the Excel data source in a Word mail merge
Connect Word to an accessible Excel workbook while keeping the original in the SharePoint library.
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.

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.




