Opening a “Blocked” Export to Excel File in Dynamics CRM

Blog Image Builder 800x600 2 Recovered 300x225 Opening a “Blocked” Export to Excel File in Dynamics CRM

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!

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.

102616 2116 OpeningaBlo1 Opening a “Blocked” Export to Excel File in Dynamics CRM102616 2116 OpeningaBlo2 Opening a “Blocked” Export to Excel File in Dynamics CRM

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.

102616 2116 OpeningaBlo3 Opening a “Blocked” Export to Excel File in Dynamics CRM102616 2116 OpeningaBlo4 Opening a “Blocked” Export to Excel File in Dynamics CRM

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!

Let’s block ads! (Why?)

PowerObjects- Bringing Focus to Dynamics CRM