Export to an Excel static worksheet
Applies to Dynamics 365 for Customer Engagement apps version 9.x
When you want to present Customer Engagement information to an individual who doesn’t have access to Dynamics 365 for Customer Engagement, or you have data that doesn’t change often, consider exporting your Customer Engagement data to a Office Excel static worksheet.You can export up to 100,000 records at a time. And by default, Dynamics 365 for Customer Engagement apps lists up to 50 records per page. Choose the Page arrows at the bottom of the list to view any additional pages.
Export data to an Excel static worksheet
You may have the option to export data to an Excel static worksheet in all record types however, in some cases the format may be legacy, or the data may not be filtered by what you see in Dynamics 365 for Customer Engagement apps view.
Open a list of records in the Customer Engagement web application or in Microsoft Dynamics 365 for Outlook. Choose Export to Excel, and then choose Static worksheet (Page only).
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths. To make changes to the columns in an Advanced Find View, choose Edit Columns. More information: Create, edit, or save an Advanced Find search
Choose Save and then save the . xlsm file. Make note of the location where you saved the file.
If you’re going to edit the data file later, it’s recommended that you save the file before you open it. Otherwise, you may get this error message: Excel cannot open or save any more documents because there is not enough available memory or disk space.
To fix the issue do this:
Open Excel and go to File > Options > Trust Center Settings Center Settings… > Protected View.
2. In Protected View, uncheck all three items.
3. Then choose OK > OK.
We still strongly recommend that you save and then open the data file, rather than disabling protected view, which may put your computer at risk.
Open Office Excel and then open the . xlsm file you saved in the previous step.
By default, an exported worksheet includes the fields that are displayed in the list, using the same field order, sorting, and field widths.
You can email a static exported worksheet to anyone, or store it in a shared file. Anyone who opens the file will see all the data in the file, whether or not they are a Dynamics 365 for Customer Engagement user or have privileges to view the data in Dynamics 365 for Customer Engagement.
You can’t change the columns for a system view, such as All Active Accounts. You must either customize the view, which requires the System Administrator or System Customizer security role, or use Advanced Find to create your own view based on the current view.
In Dynamics 365 for Customer Engagement, money values are exported to Excel as numbers. After you have completed the export, to format the data as currency, see the Office Excel Help topic titled “Display numbers as currency.”
The data and time values that you see in Dynamics 365 for Customer Engagement show up as Date only when you export the file to Office Excel but the cell actually shows both the date and time.
If you’re going to make changes and import the data file back in to Dynamics 365 for Customer Engagement apps, remember that secured, calculated, and composite fields (e.g. Full Name) are read-only and can’t be imported in to Dynamics 365 for Customer Engagement apps. You’ll be able to edit these fields in Excel but when you import the data back in to Dynamics 365 for Customer Engagement apps these fields will not be updated. If you want to update these fields such as a contact’s name then it’s recommend that you use that view to export your data, update them in Excel, and import them back to Dynamics 365 for Customer Engagement apps for changes.
Export to Excel is a tool provided by the XrmToolbox community developed for Dynamics 365 for Customer Engagement Customer Engagement. See the Developer tools topic for community developed tools.
The community tools are not a product of Microsoft Dynamics and does not extend support to the community tools. If you have questions pertaining to the tool, please contact the publisher. More Information: XrmToolBox.
If you use Microsoft Dynamics 365 (online), exporting data to a static worksheet creates a local copy of the exported data and stores it on your computer. The data is transferred from Dynamics 365 (online) to your computer by using a secure connection, and no connection is maintained between this local copy and Dynamics 365 (online).
When you export to a dynamic worksheet or PivotTable, a link is maintained between the Excel worksheet and Dynamics 365 (online). Every time a dynamic worksheet or PivotTable is refreshed, you’ll be authenticated with Dynamics 365 (online) using your credentials. You’ll be able to see the data that you have permissions to view.
An administrator determines whether or not an organization’s users are permitted to export data to Excel by using security roles.