Cannot Check Out XLSM File from SharePoint 2016 in Excel 2016
Question details
Users are unable to check out macro-enabled Excel files (XLSM) from a SharePoint 2016 library.

- Product
- Excel 2016, SharePoint Server 2016
- Device & OS
- not provided
- Scenario
- A user attempts to open and check out a macro-enabled workbook from a SharePoint library for editing.
- Observed behavior
- The workbook opens in Excel but the Check Out button is missing, and the system may display an error stating the file is locked by another user.
Verify that no other user currently has the file open and that there are no background Office processes locking the file on your local machine.
Verify File Lock Status and Library Checkout Settings
Resolve the missing checkout button by ensuring the file is not locked by ghost processes or misconfigured library rules.
Often, SharePoint files appear locked or lose their checkout functionality if an Excel process previously crashed, or if another user left the document open without checking it back in.
Navigate to the SharePoint 2016 library in your browser. Hover over the XLSM document to see if it indicates being locked by another user. If it is, contact them to close and check in the file.
Close Excel 2016 completely. Open Task Manager (Ctrl + Shift + Esc) to ensure no background 'EXCEL.EXE' processes are running and holding a local lock on the file.
If you are a site admin, navigate to Library Settings > Versioning settings, and verify the 'Require documents to be checked out before they can be edited' configuration is set correctly for your workflow.

Consult a SharePoint Administrator or Support Forums
When XLSM files persistently refuse to check out, it typically points to deeper SharePoint Server 2016 configuration or server-side caching issues.
Edit and Manage Spreadsheets Easily with WPS Office
Avoid complicated server lockouts and checkout errors. WPS Office is a free, lightweight alternative to Microsoft Office that offers a familiar interface and excellent compatibility with your existing workbooks.
- 1. Download WPS Office: Visit the official WPS website to download the free, lightweight installer.
- 2. Install and Launch: Follow the on-screen instructions to install the suite and open WPS Spreadsheet.
- 3. Open your XLSM file: Go to Menu > Open and select your macro-enabled workbook to begin editing immediately.

Frequently Asked Questions
Why does Excel say my SharePoint file is locked by another user?
This usually happens if another user currently has the file open, if someone checked it out and forgot to check it back in, or if a previous session crashed and left a ghost lock on the SharePoint server.
How do I force unlock a file in SharePoint 2016?
A site administrator can go to the Library Settings, locate the 'Manage files which have no checked in version' option, or manually override the user's checkout status directly from the document library menu.
Do XLSM files behave differently in SharePoint compared to XLSX files?
Yes, macro-enabled workbooks (XLSM) sometimes require specific trusted location settings or security prompts to be accepted before they can be fully opened and checked out for editing.




