Wednesday, October 28, 2015

Immersive Excel - Accidental Updates

Immersive Excel was introduced in 2015 Spring release of Dynamics CRM and it allows you to bulk edit records using Excel online embedded directly within CRM.  It is a very popular feature and intuitive to use. There is one little caveat in that there is no validation to prevent a user accidently updating a read only field. You will need to write a custom plug in if you want to protect fields from acidential update using Excel.

To bulk edit records in Excel simply select the Open in Excel Online option to edit the current view (you need an Excel online licence for this to work).