To view and refresh data, Microsoft Dynamics CRM for Outlook must be installed

When trying to export data from CRM to a dynamic pivot table you receive the following message: “To view and refresh data, Microsoft Dynamics CRM for Outlook must be installed”, although the CRM Outlook client has already been installed and CRM is added to the Trusted Sites.


To resolve this issue follow the steps below.

1. Click on the cell which contains the message “To view and…”

2. Click on Connections [from DATA Tab]
It will open a Connection Window.

3. Click on Refresh [from Connection Window]

Now, the data will appear in the data sheet.

Happy import / export !!!!!