When I export to Excel as dynamic work sheet, i don't see any data coming. any pointers please
On a default Microsoft Dynamics CRM installation, before you export data to an Excel dynamic worksheet, make sure that:
Microsoft SQL Server server allows remote connections.
Windows Firewall allows remote SQL Server connections. See How to: Configure a Windows Firewall for Database Engine Access.
In any area with a list of records, on the <Record Type> tab, in the Share Data group, click the Export to Excel.
Click Dynamic worksheet.
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths.
Click OK, and then click Export.
view the file containing the dynamic worksheet:
i)- To view the worksheet, click Open.
ii)- If you are using Microsoft Office Excel 2007:
a)- You will see a message that says the file that you are trying to open is in a different format than specified by the file extension. Click Yes.
b)- If you see the security warning Data connections have been disabled, click Options, click Enable this content, and then click OK.
iii)- If you are using Microsoft Excel 2010:
b)- You will see a message that says that the file was opened from a potentially unsafe location. Click Enable Editing.
c)- If you see the security warning Data connections have been disabled, click Enable Content, and then click OK.
To refresh data in the file, on the Data tab in the Connections group, click Refresh All.
To save the exported data to a file, in Excel, on the File menu, click Save.
Note: Each time you open the file, you have the option to refresh data from the Microsoft Dynamics CRM database.
Check that you have the CRM Outlook Client installed on the same PC that is running the Dynamics Excel worksheet
Frank LeeCRM MVP since 2006BlogTwitter
We have two CRM clusters. Dev and Test.
1. Dev has CRM instance with SQL -2008
2. Test has CRM instance with SQL-2005.
Below solution worked on 2008 but didn't profit on 2005. Any help would be greatly appreciated. Thanks
Did you check profile permissions? What is the exact error you are getting.
I dont receive any error. but upon opening the excel file, i have user and password in 2 cells. Screen shot below. Thnaks in advance.
Check from your CRM Settings if the password protection option is set to ON. This usually happens when you set the password protection to ON mode for content deliveries.
Could you tell me where this setting is present. I am not aware of the above password protection setting in CRM. Thanks.
You have to find the user under the “All People” page, then edit him by clicking on the name. On the right side, under the “Special Actions” metabox, click on “Toggle Settings” and you will find the fields to set the password.
I am copying a link below. It may also be helpful for you.
Dynamic Worksheets and/or Dynamics Pivot Tables require the use of the Excel addin which is part of the Microsoft Dynamics CRM 2011 for Microsoft Office Outlook client. You must install the Microsoft Dynamics CRM 2011 for Microsoft Office Outlook found here:
If you are running traditional AD On-Premise, you do not need the Outlook client. However, there is a very strange behavior of the SQL-server as it for some strange reason communincates on epipherimal port (very high typically outgoing ports) instead of the normal SQL port. The port used seems to be randomized based on the SQL installation. Do not ask me why. However, I have blogged about this and how to find out using Netstat. Do read about it here: gustafwesterlund.blogspot.se/.../finding-tcp-port-for-dynamic-excel.html
Regards Gustaf WesterlundMVP, CTO and Chief Architect at CRM-Konsulternawww.crmkonsulterna.seCRM Blog
If you find answers useful, please mark them as answered, it will help all of us in the community!
I don't see any such option as "Special Actions" on user profile pages. Could you insert a screen shot for me. Thanks in advance.
Please follow the link I am copying below to learn about Excel Security Settings:
Hope this will work for you.
Change the setting in Excel to allow it to open the files in normal mode for all files originated from Internet.
a) Go to File->options.
b) Go to Trust center ->Trust Center Settings.
c) Go to Protected view.
d) Uncheck the Settings “Enable Protected view for Files Originating from internet”.
Another option is to choose Save instead of open. Then save it to the desktop then open it. This means that Excel is opening it from a local Computer and not the internet.
Muhammad has a great summary - but you also want to check your security.
aka The CRMLady at http://www.crmlady.com
It could be that EXCEL Macros are disabled by your anti-virus software. Make sure that Excel Macros are enabled.
Have you tried running NetStat when Excel tries to get the data to see if there is and handshakes that are not being successful?
After exporting your Dynamic Data and Opening it in Excel, please click the Refersh from CRM button in the Ribbon. Dynamic Export doesn't actually download any data, instead it saves the connection string information to an Excel File so that you can load the data directly in Excel.
When you click the Refresh from CRM Button it then queries your CRM Server, and retrieve your current data.
I am copying 2 links below and hope these will be of help for you: