SharePoint Document Issues

How to Open Embedded Excel Files in SharePoint Word Documents Without Checkout

Amos GikundaAmos Gikunda Oct 9, 2026 870 views

Question details

Users cannot open embedded Excel spreadsheets inside Word documents stored on SharePoint unless the entire Word document is checked out.

How to Open Embedded Excel Files in SharePoint Word Documents Without Checkout
Product
Microsoft Word, SharePoint
Device & OS
not provided
Scenario
Attempting to open an embedded Excel workbook within a Word document stored in a SharePoint library without checking out the host file.
Observed behavior
The embedded Excel file refuses to open in the desktop version of Word unless the user explicitly checks out the Word document from SharePoint.
Before you start

Ensure you have the necessary administrator or owner permissions for the SharePoint document library to access and modify the library's versioning settings.

Solution 1Recommended

Disable the Mandatory Checkout Requirement in SharePoint

Modify the SharePoint library's versioning settings so users are not forced to check out documents before editing embedded objects.

This issue is typically caused by SharePoint's library versioning rules. When a library requires checkouts, opening an embedded object in desktop Word triggers a write-access request, which fails if the document isn't checked out.

1
Access Document Library Settings

Open your SharePoint site and navigate to the specific document library where your Word document is stored. Click on 'Library Settings' (often found in the library ribbon or under the gear icon), then select 'More Library Settings'.

2
Open Versioning Settings

In the library settings panel, look under the General Settings section and click on 'Versioning Settings'.

3
Disable Checkout Requirement

Scroll down to the 'Require Check Out' section. Find the option 'Require documents to be checked out before they can be edited' and set it to 'No'.

4
Save and Test

Click 'OK' to save your changes. Open the Word document in desktop Word again and try double-clicking the embedded Excel spreadsheet to see if it opens successfully without checkout.

Disable the Mandatory Checkout Requirement in SharePoint
Contacting Support: If the mandatory checkout setting is already set to 'No' and the issue persists, contact Microsoft 365 support through the admin center. Support may request HAR logs to investigate further.
Free Microsoft Office alternative

Edit Documents and Spreadsheets Seamlessly with WPS Office

If you frequently encounter complex configuration issues and strict permission barriers with Microsoft Office and SharePoint, consider switching to WPS Office. It provides a lightweight, highly compatible alternative for handling Word documents and embedded spreadsheets without the heavy administrative overhead.

  1. 1. Download and Install: Download WPS Office for free from the official website and install it on your device.
  2. 2. Open Your Documents: Launch WPS Office and open your .docx files directly. The unified workspace supports Word, Excel, and PDF files in one window.
  3. 3. Manage Embedded Files Easily: Double-click embedded spreadsheets to edit them instantly using WPS Spreadsheet, without worrying about complex server checkout policies.
Highly compatible with Microsoft Word (.docx) and Excel (.xlsx) formats.Lightweight and fast, helping you bypass complex library checkout restrictions.Familiar user interface makes migration effortless for existing Office users.Free to use with comprehensive document and spreadsheet editing tools.
microsoft office alternative - wps office

Frequently Asked Questions

Why does SharePoint require me to check out a Word document?

SharePoint administrators often enable mandatory checkouts to prevent multiple users from editing a document simultaneously. This ensures only one person can make changes at a time, avoiding version conflicts.

Can I open embedded Excel files without editing the Word document?

Typically, embedded objects require write access to the host document to be fully activated and opened in desktop Word. If SharePoint enforces checkouts, this write-access request will fail until the file is checked out.

What are HAR logs and why would Microsoft Support need them?

HAR (HTTP Archive) logs record web browser interactions and network requests with a site. Support uses them to diagnose background network errors and permission conflicts when SharePoint settings do not behave as expected.