POWEROBJECTS

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

Send us a message

Have you ever run into an issue when using the Export to Excel feature within Microsoft Dynamics CRM where the file successfully exports, but does not open in Excel? If so, today’s blog will show you two easy steps to fix this issue. Let’s dive in!

Export to Excel

1. Manually remove the block on the downloaded file.
One possible cause may be that your browser is placing a “block” on the Excel file downloaded from CRM. The block can be manually removed by going into the file’s properties (right-click the file) and checking “Unblock” at the bottom of the General tab.

Export to Excel

2. Add your CRM’s URL to the list of trusted sites.
Changing the Trusted Sites settings to include your CRM URL will allow you to save future files without a block. You can do this in Excel by going to File > Options > Trust Center > Trust Center Settings > Trusted Locations > Add new location, and then enter your CRM’s URL as a trusted file source.

Export to Excel

These two quick troubleshooting tips should resolve any sudden changes to your ability to export to Excel from CRM. If you want to learn more about the Export to Excel feature, check out our blog on understanding the difference between Static Worksheet and Static Worksheet (Page Only).

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.