Forum Discussion
Responsive ResidentOrganizational Data Types in Excel Now Missing
Agree. Magically my Organization Data Types began working today as well.
I found that this is issue is now tracked between known issues by microsoft. Known issue - Excel enterprise data types feature experiences issues - Microsoft Fabric | Microsoft Learn
23 Sep 2024 8:45 CEST
Today the organzational data types work in our environment suddenly again. Unfortunately it is not clear, if anything was done in PBI or if it works because something else changed.
IamTDRAgree. Magically my Organization Data Types began working today as well.
One of my collegues has send me the link that the feature is discontinued and not supported any longer from July 31st, 2025.
https://support.microsoft.com/en-us/office/use-organization-data-types-to-view-and-insert-data-c7686113-f906-40c8-b9eb-d97c41702469Too bad, many colleagues found this direct integration into Excel very useful, I cannot see it to be replaced with PBI or custom Excel AddIn with the current functionality.
Honestly, this is ridiculous. Microsoft keeps killing off good features for no real reason. And the “solutions” they suggest — like connecting to Power BI or using custom add-ins — are just not the same.
Organization data types still work fine in Office 365 web and even in older versions of Excel, lets see for how long.
I have observed that it is working for lines which I had already in the feature table before 19 Sep. Any new lines are not being converted.
everromanrMicrosoft Employee
Hello IamTDR
I can confirm Microsoft Product Group team in charge of this bug started to release the fix by 09/21 EOD, for that reason we see the feature is working again, thanks for your patience and we apologize all the inconveniences caused.