✏️ Explanatory Question

What is a key improvement related to Export to Excel in Dynamics 365 Finance and Operations platform update 22 (December 2018)? Explain how it can be configured.

👁 7 Views
📘 Detailed Answer
🟢 Easy
💡

Answer with Explanation

In Dynamics 365 Finance and Operations platform update 22 (December 2018), how many rows can users export to Excel from a grid, and how can this limit be configured?

In Dynamics 365 Finance and Operations platform update 22 (December 2018), Microsoft significantly enhanced the Export to Excel feature.

Previously, users could export a maximum of 10,000 rows from a grid. With platform update 22:

  • Users can export up to 1 million rows to Excel.

  • The default export limit is set to 50,000 rows.

  • System administrators can increase this limit up to 1,000,000 rows.

The export limit can be configured by administrators through the:

  • Client performance options page

This enhancement is especially useful for:

  • Large data analysis

  • Reporting

  • Auditing

  • Operational reviews without custom development

Ref: https://learn.microsoft.com/en-us/dynamics365/fin-ops-core/dev-itpro/get-started/whats-new-platform-update-22