SharePoint Check-in not Behaving the same across Microsoft office

Question

SharePoint Check-in not Behaving the same across Microsoft office

Silas Wharton 0

Good morning,

We are having a issue where our Check in behavior to SharePoint 2019 is not behaving the same across different Microsoft Office Apps. When editing a "Word" document in the app, we are able to check in a file continuously to the SharePoint library it was checked out from. But, when users are editing an "Excel" file from within the app, you can only check in a document once before it loses its connection to the SharePoint Library (sync arrow on save icon disappears). Not sure which setting would be causing this difference in behavior for different Office apps using the same SharePoint library.

P.S This is a environment with no access to internet

0 comments

3 answers

Your answer

Answer 1

Hi Silas,

This looks more like an Excel client integration issue than a SharePoint library configuration issue.

I would recommend checking a few things:

Check-in status: After checking in from Excel, verify whether SharePoint shows the file as checked in. If it does, Excel may simply be ending the checkout session.

Office version: Compare the Excel and Word versions/builds and ensure they are up to date with your organization's approved updates.

Office Document Cache: Try clearing the cache through the supported Office settings, as cache issues can sometimes affect SharePoint integration.

Test another machine: Open the same workbook on another workstation to determine whether the issue is specific to the Office installation.

Also, try checking the workbook out again directly from Excel (File → Info → Check Out) after the first check-in.

Answer 2

Hello Silas Wharton,

Based on your description, this appears more likely to be an Office client integration difference between Word and Excel rather than a SharePoint library configuration issue, since both document types are stored in the same SharePoint 2019 library but exhibit different check-in behavior.

To help isolate the cause, I'd recommend the following troubleshooting steps:

1. Verify the document status in SharePoint after Excel checks in the file

After performing the check-in from Excel:

Refresh the SharePoint library.
Confirm whether the workbook is still shown as checked out.
Compare the result with a Word document in the same library.

If SharePoint shows the workbook as successfully checked in and no longer checked out, Excel may simply be ending the checkout session as part of its normal workflow. If SharePoint still shows the file as checked out while Excel loses the SharePoint connection indicator, that would point to a client-side issue.

2. Test with a newly created workbook

To determine whether the issue is workbook-specific:

Create a brand-new XLSX file.
Upload it to the same library.
Check it out, edit it, and perform multiple check-in/check-out cycles.

3. Test another workstation

If possible, test:

Same workbook
Same SharePoint library
Different workstation/user

This will help determine whether the issue follows the workbook, the user profile, or the local Office installation.

4. Clear the Office document cache

If your Office version includes the Office document cache functionality, clear the cache using Microsoft's supported method and then retest. Corrupted cache entries can sometimes affect SharePoint document synchronization behavior.

Important note regarding supportability

It's also worth noting that SharePoint Server 2019 reached end of extended support on July 15, 2026. Microsoft no longer provides security updates, bug fixes, or technical support for this product. Organizations are encouraged to plan a migration to either SharePoint Server Subscription Edition (for on-premises deployments) or SharePoint Online.

I hope this information helps.Kind Regards.

Answer 3

Check Excel’s Check In dialog for an option to keep or leave the workbook checked out; enable it when available, because a normal check-in ends the checkout, whereas Office clients can expose content-editing options that leave the document checked out on the server.^1^

Verify which behavior is occurring

Open the workbook from the SharePoint library and check it out.
In Excel, select File → Info → Check In.
In the Check In dialog, look for an option that keeps/leaves the workbook checked out after creating the version.
- If present, select it before completing the check-in.
- Compare this dialog with Word’s check-in dialog on the same computer. Availability and wording can differ by Office application and build; Microsoft’s public documentation does not establish the exact Excel checkbox text for every SharePoint Server 2019/Office combination.
Immediately after checking in, inspect the workbook in the SharePoint library:
- Checkout icon gone: Excel completed the check-in and ended the checkout. The disappearance of Excel’s server/sync indicator may therefore represent the completed workflow, not a dropped connection.
- Workbook still shown as checked out to the user: Excel has lost its active SharePoint state unexpectedly and requires client-side investigation.

SharePoint Server 2019 permits repeatedly saving a checked-out document without creating a visible version. A new version becomes visible when it is checked in. Office clients may also offer content-editing options to leave the document checked out.^1^

If Excel does not offer “keep checked out”

No documented SharePoint library setting forces Excel to retain the checkout after every check-in. Use this reliable fallback:

Finish the check-in in Excel.
In the SharePoint library, select the workbook and choose … → Check out. In the classic experience, use Files → Check Out.
Reopen the workbook in Excel before continuing to edit.
When finished, use File → Info → Check In, enter a comment, and select OK.^2^

This creates separate controlled versions while avoiding reliance on a Word-only or build-specific dialog option.

If SharePoint still shows the workbook checked out

That indicates a synchronization/client integration problem rather than a normal completed check-in.

Protect current changes first. Save a temporary local copy of the workbook before clearing or repairing anything.
Record:
- Excel edition and full build from File → Account → About Excel.
- Whether .xlsx and .xlsm files behave identically.
- Whether the problem follows the user, workstation, or workbook.
Test a new .xlsx workbook in the same library and the affected workbook from another workstation with the same Office build. This separates workbook-specific behavior from an Excel build or machine issue.
If the installed Office version provides Microsoft Upload Center, use Upload Center → Settings → Delete Cached Files, then restart Windows and retest. Do not manually delete the Office cache folder; Microsoft warns that manual removal can cause crashes or unrecoverable data loss.^3^ The supported Upload Center procedure is documented separately.^4^

A reported Microsoft 365 Apps regression in versions 2509 and 2510 involved Excel losing synchronization while a workbook remained checked out. That report is applicable only if synchronization disappears independently during editing—not merely after a completed check-in. If your deployment matches those builds, have the Office deployment administrator test the previously working build and open a Microsoft Support case with the Excel build, SharePoint patch level, reproduction steps, and logs.^5^

The absence of Internet access does not by itself identify the cause here. The relevant connection is between Excel and the on-premises SharePoint Server; first determine whether SharePoint ended the checkout or still records it as active. If the latter persists after build and cache isolation, escalate through the organization’s Office/SharePoint administrators and then Microsoft Support.

References