File Sharing Problems

How to Get Notified When Someone Closes a Shared Excel Workbook

Adam Davis Oct 15, 2026 868 views

Question details

The user wants to receive an alert or notification when another collaborator finishes editing and closes a locked, shared Excel workbook.

How to Get Notified When Someone Closes a Shared Excel Workbook

Product: Microsoft Excel
Device & OS: not provided
Scenario: Waiting to edit a locked or read-only shared Excel file and needing to know exactly when it becomes available for editing.
Observed behavior: Modern Excel does not provide a built-in notification or standard alert to tell a user when another user closes a shared workbook.

Before you start

Verify where your Excel file is stored (e.g., local network drive, OneDrive, or SharePoint), as your storage location determines which collaboration and notification features are available to you.

Solution 1Recommended

Transition to Cloud Co-authoring

Instead of waiting for a file to be closed, use modern cloud co-authoring to edit the workbook simultaneously with other users, eliminating the need for close notifications.

The traditional 'file locked for editing' issue mostly occurs on local network drives. By moving the file to Microsoft's cloud services, multiple people can edit the same document at the same time.

Upload the file to the cloud

Save your Excel workbook to OneDrive or SharePoint using the 'Save As' menu in Excel.

Share the workbook

Click the 'Share' button in the top right corner of Excel and send an editing link to your collaborators.

Edit simultaneously

Open the file while others are in it. You will see their cursors in real-time, meaning you no longer have to wait for them to close the file to make your changes.

Co-authoring Advantage: Co-authoring completely bypasses the read-only restriction, making traditional file-close notifications unnecessary.

Solution 2

Use SharePoint Check-In Alerts

If you require strict version control and need to know when someone finishes an update, use SharePoint's 'Check Out' feature combined with automated alerts.

Solution 3

Communicate Manually via Teams or Email

Since there is no automated trigger for closing a network-hosted file, manual communication remains the most reliable fallback method.

Free Microsoft Office alternative

Experience Seamless Spreadsheet Collaboration with WPS Office

Struggling with locked files and missing notifications in Excel? Switch to WPS Office. It offers robust cloud collaboration tools, real-time co-authoring, and a highly compatible spreadsheet editor without the hefty price tag.

Fully compatible with Microsoft Excel formats (.xlsx, .xls, .csv)Built-in cloud storage for real-time team collaborationLightweight installation with fast performance on any deviceFamiliar user interface ensuring zero learning curve for Excel users

microsoft office alternative - wps office

Frequently Asked Questions

Why did older versions of Excel have a 'Notify' button for read-only files?

Older versions of Excel hosted on local network servers sometimes offered a 'Notify' button when a file was locked. This would place a temporary read-only copy on your screen and alert you when the original file was closed. This legacy feature is largely deprecated in modern cloud-centric Office environments.

Can I force another user to close a shared Excel file?

You cannot directly force a close from within Excel. However, if the file is on a local network server, a network administrator can manually close the open file session from the server's Computer Management console. If hosted on SharePoint, an admin can discard another user's check-out.

Can Power Automate send a notification when an Excel file is closed?

Power Automate does not have a specific trigger for 'when a file is closed'. However, you can create flows that trigger when a file is modified or when a file's properties are updated in SharePoint, which usually happens immediately after a user saves and exits the document.

Document & File Issues