POWEROBJECTS

718 Washington Ave. N. Suite #101
Minneapolis, MN 55401
View map and all Locations

Send us a message

Ever want to do mass updates to Opportunities in CRM but many of the records that need to be updated are closed? Well, it’s easy to do with CRM 2011’s “Make this data available for re-importing” feature!

crm-101

Why would you want to mass update closed Opportunities in CRM 2011? One reason is that you may want to remove an option set value. You can’t simply delete it without leaving the field blank on the closed records, so it needs to be mapped to another value.

If you want to learn more about the Data Import Wizard before proceeding, check out these other posts:

Ready to update some records?

  1. Create an Advanced Find view for the records that need to be updated. In this example, we can see that “no response” and “no decision” are really telling us the same thing, so we want to change all the “no response” values to “no decision” and remove “no response” from the option set.

    bulk update closed opportunities in CRM 2011

  2. Run the Advanced Find query and then press the How to Mass Update Closed Opportunities in CRM 2011 button on the ribbon.
  3. In the resulting dialog box, check “Make this data available for re-importing by including required column headings and press the Export button. (Note: If your query returns more than one page, the dialog box will have an option to export all rows from all pages. Also select this option.)

    How to Mass Update Closed Opportunities in CRM 2011

  4. Save and Open the file in Excel.

    How to Mass Update Closed Opportunities in CRM 2011

  5. Edit the column that needs to be updated. In this example, we are changing the Status Reason from No Response to No Decision. Because this is an option set in CRM, it is an option set in Excel as well.

    How to Mass Update Closed Opportunities in CRM 2011
    How to Mass Update Closed Opportunities in CRM 2011

  6. Save the changes in Excel. You will receive the following alert. Press “Yes” to continue.

    How to Mass Update Closed Opportunities in CRM 2011

  7. On the Opportunity list view, press the Import Data button on the ribbon.

    How to Mass Update Closed Opportunities in CRM 2011

  8. In the Upload Data File dialog box, browse for the file and press Next and then Submit. The records will be updated.

In our scenario, we also needed to then go back and remove the discontinued value from the Option Set so it would not be available for future selection, and then we were done.

Need more information on Option Sets? Check out When to use a Global Option Set vs a Custom entity.

Happy CRM’ing!

Avatar for JoeCRM

JoeCRM

Joe CRM is a CRM superhero who runs on pure Microsoft Dynamics CRM adrenaline. As the face of PowerObjects, Joe CRM’s mission is to reveal innovative ways to use Dynamics CRM and bring the application to more businesses and organizations around the world.