File Sharing Problems

How to Set Up Email Alerts When a Shared Excel File Changes

WPS Editor Oct 12, 2026 870 views

Question details

Users need to receive email notifications when a shared Excel document is updated, particularly when the default SharePoint or OneDrive alert options are unavailable or fail to trigger.

How to Set Up Email Alerts When a Shared Excel File Changes

Product: Microsoft Excel
Device & OS: not provided
Scenario: Setting up notifications for manual file edits or automated form submissions in a shared spreadsheet.
Observed behavior: The 'Alert Me' option is missing from the menu, or emails are not being sent when new form entries automatically populate the Excel file.

Before you start

Ensure you have the appropriate site permissions in SharePoint or OneDrive, as standard users with view-only access may not be able to configure specific alerts or create automation flows.

Solution 1Recommended

Enable Alerts Using the SharePoint 'Alert Me' Feature

Use this default method if your organization allows standard SharePoint notification features to track edits on your shared Excel file.

The built-in 'Alert Me' function is the simplest way to get notified when someone changes a document. However, it requires specific site permissions and might be disabled by your IT administrator.

Open SharePoint or OneDrive

Navigate to the document library where your shared Excel file is stored.

Select the Excel File

Hover over the file name and click the three-dot (ellipsis) icon next to it to open the context menu.

Choose Alert Me

Click on 'Alert Me' from the dropdown menu. If you do not see this option, you may not have sufficient permissions.

Configure Notification Settings

Set your preferences for when to receive alerts (e.g., all changes, or only when someone else changes the document) and click 'OK' to save.

Enable Alerts Using the SharePoint 'Alert Me' Feature

Solution 2

Create a Notification Flow with Power Automate

Use Power Automate if the 'Alert Me' option is missing or if the Excel file is populated automatically by forms or background processes.

Free Microsoft Office alternative

Easily Share and Collaborate with WPS Office

Avoid complex SharePoint setups and missing alert buttons. WPS Office offers a free, lightweight alternative with seamless Microsoft Excel format compatibility, familiar interfaces, and easy-to-manage cloud file sharing.

1. Download and Install: Get WPS Office for free from the official website and install it on your device.
2. Open Your Excel File: Open your existing .xlsx spreadsheets directly in WPS Office without losing any formatting.
3. Share via WPS Cloud: Upload your file to WPS Cloud and share it securely using a customizable link for real-time collaboration.

Fully compatible with Microsoft Excel (.xlsx, .xls, .csv) formatsFree and lightweight alternative to Microsoft OfficeFamiliar UI makes migration seamless and intuitiveBuilt-in WPS Cloud for simple link sharing and real-time collaboration

Frequently Asked Questions

Why is the Alert Me option missing in SharePoint or OneDrive?

The 'Alert Me' feature may be unavailable if your organization's IT department has disabled SharePoint alerts globally, or if you do not have sufficient permissions to manage notifications for that specific document library.

Can I receive alerts when a Microsoft Form adds data to my Excel file?

Default SharePoint alerts often do not trigger when automated processes like Forms update a file. To fix this, you must create a Power Automate flow triggered by 'When a new response is submitted' to send the email notification instead.

Can I set up email alerts for an Excel file shared with me by someone else?

Yes, as long as the file owner has granted you sufficient permissions. You can use Power Automate to create a personal flow that monitors the shared file and sends an email to your inbox whenever it is modified.

Document & File Issues