SharePoint Document Issues

Cannot Check Out XLSM File from SharePoint 2016 in Excel 2016

Kushani NimanthikaKushani Nimanthika Oct 26, 2026 869 views

Question details

Users are unable to check out macro-enabled Excel files (XLSM) from a SharePoint 2016 library.

How to Fix Cannot Check Out XLSM File from SharePoint 2016 in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Check for active users

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.

2
Clear local Excel background processes

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.

3
Review versioning and checkout settings

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.

Verify File Lock Status and Library Checkout Settings
Admin Override: If the file is locked by an unknown user, a SharePoint Administrator can override the checkout from the Library Settings menu.
Free Microsoft Office alternative

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. 1. Download WPS Office: Visit the official WPS website to download the free, lightweight installer.
  2. 2. Install and Launch: Follow the on-screen instructions to install the suite and open WPS Spreadsheet.
  3. 3. Open your XLSM file: Go to Menu > Open and select your macro-enabled workbook to begin editing immediately.
Highly compatible with Microsoft Excel formats including .xlsx and .xlsmFree, lightweight, and fast to download and installFamiliar ribbon user interface allows for seamless migrationEasily share and collaborate without complex server checkout rules
microsoft office alternative - wps office

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.