Services
Summary
Organization Data Types in Microsoft Excel for Microsoft 365 will retire on July 31, 2025. Users should switch to Power BI or custom Excel add-ins. Existing data types will remain but won't refresh. Bing data types are unaffected. For preparation, connect Excel to Power BI or explore custom add-ins.
Details
As announced in MC1072405 (May '25), we're retiring Organization Data Types in Microsoft Excel for Microsoft 365. This change simplifies the data types experience and encourages use of more robust, supported solutions like Power BI and custom Excel add-ins.
When this will happen:
This change will take effect on July 31, 2025.
How this affects your organization:
Starting July 31, 2025:
- Organization Data Types will be removed from the Data Types gallery on the Data ribbon tab in Excel.
- Users will no longer be able to convert values to new organization data types.
- Existing organization data types in workbooks will remain but will no longer refresh.
This change does not affect Bing data types, which will continue to be supported.
What you can do to prepare:
If your users rely on Organization Data Types, we recommend:
- Connecting Excel to Power BI to access organizational data.
- Exploring custom add-in solutions using the Excel Data Types APIs.
For guidance, refer to: