Get an Email Notification when Someone Edits Your Excel Report

Learn how to set up an email notification to notify you whenever someone edits your Excel workbook.
In this video, we'll use Microsoft Flow to send an email notification to let us know our workbook has been modified and who it was modified by. 👇
Check out my full courses and ebooks here
👉 www.howtoexcel.org/courses/
DOWNLOAD the example workbook here
📖 www.howtoexcel.org/downloads/
SUBSCRIBE & get my 3 FREE eBooks
📧 www.howtoexcel.org/newsletter/
CONNECT with me on social
Facebook: / howtoexcelblog
Twitter: / howtoexcelblog
LinkedIn: / john-macdougall
Thanks for all your support!

Пікірлер: 29

  • @amelieleclerc22
    @amelieleclerc223 ай бұрын

    Thank you it was SO helpful! It worked perfectly I now receive an email notification each time someone modify my excel file 🙌🏻 The thing is, I also receive an email when I myself modify the excel file (which I do 100 times a day) can you please explain if I can add an exception to this trigger, so that I don't get an email when I'm the one that modified the excel file?

  • @binny9820
    @binny98202 жыл бұрын

    Hi John, great video thanks for the info. Is there any way of breaking this down further by getting a notification if a particular tab was edited in excel?

  • @wayneedmondson1065
    @wayneedmondson10655 жыл бұрын

    Hi John.. thanks.. good tip. Thumbs up!

  • @logansimmons3199
    @logansimmons3199 Жыл бұрын

    My friend told me his teacher used this for his class to make sure students weren't cheating. I thought he was lying to the students because a lot of the professors like to do that at my school. I investigated the cell he was talking about and didn't see anything off. Turns out it's not an Excel function and it's Flow instead. Thanks for clearing this up for me.

  • @anilkumar-ml2sl
    @anilkumar-ml2sl Жыл бұрын

    Nice explanation, thanks for this. But my requirement is that if we add any new data to Excel file then only it should trigger an email, and not just at opening the file and clicking somewhere which is treated as 'changed' in online SharePoint

  • @vidyasagar.Canada
    @vidyasagar.Canada Жыл бұрын

    Nice work, thanks

  • @user-ahmad-matar
    @user-ahmad-matar5 жыл бұрын

    Thanks a lot It's really useful

  • @HowToExcelBlog

    @HowToExcelBlog

    5 жыл бұрын

    No problem!

  • @markopopoland
    @markopopoland2 ай бұрын

    Is it possible to include to email exactly what has been changed ?

  • @Daza409
    @Daza40929 күн бұрын

    I'm having a problem with this due to just opening and viewing the sheet counts as an edit, how do I get around this?

  • @alpesta
    @alpesta7 ай бұрын

    Hey, thanks. Is it possible to specify a value. For instance when someone assigns "Apple" to a cell, I wanna be informed.

  • @midomado9192
    @midomado9192 Жыл бұрын

    Many thanks for sharing this video! I have only one small question, is there any way in the excel to make an alert/ notification; sending an email, by editing or updating the sheet. This function is available in the google sheets, but no idea how to find this in excel if there is any.

  • @provoschoolbus
    @provoschoolbus2 жыл бұрын

    I feel like there should be a button, or toggle switch for this.

  • @user-fr8gn7fs4g
    @user-fr8gn7fs4g Жыл бұрын

    Hi John! I am trying to create a flow that will give a daily email at the end of the day with who modified a specific file during that 24 hour day. If you could explain how to do this that would be great because every time i try to create this it gives me the wrong kind of email or errors. I am really struggling with this so if you could help me that would be great!

  • @starrprice896
    @starrprice896 Жыл бұрын

    Is there a way to have an option to send out the email or not and/or edit the email before sending it out so that an additional attachment can be added?

  • @ChloeVaughan-mt6gg
    @ChloeVaughan-mt6gg Жыл бұрын

    Hi John, Is there a way to show when a file has been edited only by some people? This way I can exclude myself as I obviously don't need to be notified if I edit the document. Thanks!

  • @mariajauslin1107
    @mariajauslin11073 жыл бұрын

    What if the file is saved on OneDrive? Do I still need to select "Sharepoint" as a trigger?

  • @karthikreddy9810
    @karthikreddy98103 жыл бұрын

    Nice video, can you please clarify me ,how to do this for a particular column or a row

  • @HowToExcelBlog

    @HowToExcelBlog

    3 жыл бұрын

    Not sure that is possible.

  • @moe.szyslak
    @moe.szyslak4 жыл бұрын

    Hi there, excellent video, but do you know how to add the new and old content into that email notification? Also, if you modify bit part of data, lets say 10 cells, will you receive 10 emails or only one until the user stop working on the file?

  • @HowToExcelBlog

    @HowToExcelBlog

    4 жыл бұрын

    What do you mean by new ans old content? You want to attach the current and previous versions of the workbook to the email? You should only get one email as it's based on the modified date which only changes when they close the file.

  • @moe.szyslak

    @moe.szyslak

    4 жыл бұрын

    @@HowToExcelBlog Thanks for the reply. I am looking to get an email notification with the summary of changes. Example: A user changes the content in one cell on the excel "On site" to "Talk with Felipe", and I would like to receive an email that will mention > Old value > On Site, New Value > Talk with Felipe. Do you think this is possible?

  • @Australiaspousevisa
    @Australiaspousevisa Жыл бұрын

    Hi mate, I want to make flow for my online tracker(share point) if someone external guy opening my tracker that should be notified

  • @rishitshah4087
    @rishitshah40872 жыл бұрын

    can we make notification based on particular cell for eg if the price go above 50 then notify me like that

  • @KarlijnvanA
    @KarlijnvanA3 жыл бұрын

    Hi John, do you per chance know how to get an update daily, but only if the excel report has been updated? I already made the flow where the forms reaction output is input for my excel report, but would like to get a daily reminder if people have entered information into the form (and thus the excel report). Cause an email with every entry will send me into overload in about 6 minutes when there is a lot of activity :)

  • @HowToExcelBlog

    @HowToExcelBlog

    3 жыл бұрын

    You could create a scheduled flow for every day, then list rows in the Excel table but use the Odata filter to only return items with today's date, then only send an email if there's one or more rows.

  • @jayfab4689

    @jayfab4689

    2 жыл бұрын

    @@HowToExcelBlog I am a novice. Followed your directions step by step. However, I am getting email notifications every minute.

  • @krushalchaudhary9882
    @krushalchaudhary98823 жыл бұрын

    why did you not select "When a file is modified (properties only) - ONE DRIVE" instead of SHAREPOINT ? WHats the difference ? When I open my ONEDRIVE, the URL contains "sharepoint" word in it, what does that mean ?

  • @FelipeRicco
    @FelipeRicco2 жыл бұрын

    WOW! Google Sheets is so much simpler... Poor MS. Thanks anyway!