Microsoft Excel: Organization data types will retire

Microsoft Excel will retire the Organization data types feature on July 31, 2025, due to low usage and high costs. Users are advised to use the “Get Data > From Power BI” import feature or an add-in for custom entities. This change affects all Excel platforms, but existing data will be preserved without refresh capability. Bing data types remain supported. We will retire Organization data types in Microsoft Excel effective July 31, 2025. This feature has low usage and high ongoing sustaining costs. Instead, we recommend customers switch to the Get Data > From Power BI import feature on the Data ribbon in Excel to import data from Power BI or an add-in to create custom rich entities for the organization. This retirement affects Excel for Windows desktop, Excel for Mac desktop, Excel for the web, and Excel for iOS/Android. After this retirement, we will remove the Organization option from the Data Types gallery on the Data tab on the ribbon, and users will not be able to convert values to new organization types. Existing data in workbooks that used the Organization data type will be preserved but will no longer refresh. This change will have no impact on Bing data types, which we will continue to support. Learn more Use Organization data types to view and insert data – Microsoft Support Connect Excel to Power BI semantic models – Power BI | Microsoft Learn Overview of data types in Excel add-ins – Office Add-ins | Microsoft Learn Message ID: MC1072405

The post Microsoft Excel: Organization data types will retire appeared first on M365 Admin.