1

I am looking for a feature if we could map an excel rows in SharePoint or any other mechanism to generate an email after row in excel has been changed.

**Problem **

Our customer uses SharePoint to share an excel file which contains list of Methods that needs to be implemented with each one has its own statuses as , Proposed, Inprogress , Implemented , Changed . Every developer (Offshore and onsite even the customer) will have an access to this excel and they would change it and some times forget to email the changes that they have done . I have looked up in the internet to know if there is an feature available in SharePoint to generate an automated email once the excel is updated with the row number .

So far i have seen we can sync the data from an excel to Custom list but this is not exactly what i wanted. Any solutions ? or atleast put me in right direction so that i could find a solution for this problem

  • Yeah, use a proper issue tracker – MdMazzotti Apr 20 '15 at 7:32
  • @MdMazzotti , thanks for the comment please understand i was only asking for a very specific feature or any guidance to put me in a path where i could find a solution. – ansar Apr 20 '15 at 8:22
0

I am not aware of any oob sharepoint functionaliteis that captures changes in excel. You can follow either of the two approaches below.

  1. If you sync the excel file to a sharepoint list, it would be extremely easy to co-ordinate issue tracking. (I know this is what you want, but it would simply make things a lot easier and would help you leverage sharepoint better). Simply have a custom list that you can sync sharepoint data to. And implement a basic sharepoint designer workflow that sends mail on item updated.
    Sending Emails from SPD workflows
    Workflow Events Actions

  2. If you only wanna use excel emailing capabilities, then you need to go with excel macros. This msdn article is a great source if you wanna learn about excel email capabilities.

  • thanks for the answer , i would prefer the excel macro over a custom list . – ansar Apr 20 '15 at 9:34

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.