check before: 2025-07-31
Product:
Microsoft 365 Apps, Microsoft 365 for the web, Microsoft Search, Power BI, Windows
Platform:
Android, iOS, Mac, Online, Web, World tenant
Status:
Change type:
User impact, Admin impact, Retirement
Links:
Details:
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.
Change Category:
XXXXXXX ... free basic plan only
Scope:
XXXXXXX ... free basic plan only
Release Phase:
Created:
2025-07-02
updated:
2025-07-02
Task Type
XXXXXXX ... free basic plan only
Docu to Check
XXXXXXX ... free basic plan only
MS How does it affect me
XXXXXXX ... free basic plan only
MS Preperations
XXXXXXX ... free basic plan only
MS Urgency
XXXXXXX ... free basic plan only
MS workload name
XXXXXXX ... free basic plan only
linked item details
XXXXXXX ... free basic plan only
summary for non-techies**
XXXXXXX ... free basic plan only
Direct effects for Operations**
Retirement of Organization Data Types
Users will lose the ability to refresh existing organization data types in Excel, leading to outdated information in their workbooks.
- roles: Data Analysts, Business Users
- references: https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview, https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
Increased reliance on Power BI
Users will need to transition to Power BI for organizational data, which may require additional training and adjustment time.
- roles: Data Analysts, IT Support
- references: https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
Need for Custom Add-ins
Users may need to develop or adopt custom Excel add-ins to replace the functionality of organization data types, which could lead to delays and increased workload.
- roles: Developers, Data Analysts
- references: https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
User Experience Disruption
The removal of organization data types may disrupt workflows for users who rely on this feature, leading to frustration and decreased productivity.
- roles: Business Users, Data Analysts
- references: https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
" target="_blank" rel="nofollow noopener noreferrer">https://learn.microsoft.com/office/dev/add-ins/excel/excel-data-types-overview
Data Integrity Issues
Without the ability to refresh organization data types, users may face data integrity issues, as their reports and analyses will be based on stale data.
- roles: Data Analysts, Business Users
- references: https://learn.microsoft.com/power-bi/collaborate-share/service-connect-power-bi-datasets-excel
Configutation Options**
XXXXXXX ... paid membership only
Potentional Risks**
XXXXXXX ... paid membership only
IT Security**
XXXXXXX ... paid membership only
explanation for non-techies**
XXXXXXX ... free basic plan only
** AI generated content. This information must be reviewed before use.
a free basic plan is required to see more details. Sign up here
A cloudsocut.one plan is required to see all the changed details. If you are already a customer, choose login.
If you are new to cloudscout.one please choose a plan.
Last updated 1 month ago ago
