How to Open Embedded Excel Files in SharePoint Word Documents Without Checkout
Question details
Users cannot open embedded Excel spreadsheets inside Word documents stored on SharePoint unless the entire Word document is checked out.

- 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.
Ensure you have the necessary administrator or owner permissions for the SharePoint document library to access and modify the library's versioning settings.
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.
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'.
In the library settings panel, look under the General Settings section and click on 'Versioning Settings'.
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'.
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.

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. Download and Install: Download WPS Office for free from the official website and install it on your device.
- 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. Manage Embedded Files Easily: Double-click embedded spreadsheets to edit them instantly using WPS Spreadsheet, without worrying about complex server checkout policies.

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.




