Excel Users, Brace Yourselves: A Feature Is Vanishing

In a recent announcement, Microsoft revealed its decision to retire the Organization data types feature in Excel by July 31, 2025. This move comes as a surprise to many Excel users, as the tool provided a convenient way to access and utilize organizational data within spreadsheets. Microsoft cited low usage and high ongoing maintenance costs as the key reasons behind this decision. As a result, Excel users across all platforms, including Windows desktop, Mac desktop, web, iOS, and Android, will be impacted by this change.

The Retirement of Organization Data Types

So, what does the retirement of the Organization data types feature actually mean for Excel users? Once the retirement takes effect, the Organization option will no longer be available in the Data Types gallery within the Data tab of Excel. While existing data in workbooks that utilized this feature will be preserved, it will no longer be refreshed automatically. This can pose a challenge for users who heavily relied on this feature for accessing up-to-date organizational data within their spreadsheets.

Transitioning to the "Get Data > From Power BI" Feature

To address this change, Microsoft recommends that users transition to the "Get Data > From Power BI" import feature in Excel. This alternative method allows users to continue importing organizational data into their Excel workbooks seamlessly. While making this switch may require some adjustments to your current workflow, mastering this new feature will ensure that you can continue working with organizational data effectively.

Other Changes in the Microsoft 365 Admin Center

In addition to the retirement of the Organization data types feature, the Microsoft 365 Admin Center has recently published several other significant changes. These include extending Windows 10 support for M365 apps until 2028, as well as placing two feature rollouts—Outlook enable/disable options and unified management of Teams and Outlook—on hold. These updates reflect Microsoft's ongoing efforts to streamline its services and improve user experience within the Microsoft 365 ecosystem.




Excel plays a crucial role in many professional environments, and staying informed about upcoming changes is essential for maximizing your productivity. As Microsoft phases out the Organization data types feature, it's important to adapt to alternative methods like the "Get Data > From Power BI" feature to continue working efficiently in Excel. To stay ahead of the curve and master essential Excel skills, consider exploring CtrlSquiggly. From practical tips to hands-on guidance, CtrlSquiggly offers a refreshing approach to learning Excel that is both effective and enjoyable.

Whether you're a seasoned professional looking to enhance your Excel skills or a student eager to excel in spreadsheet management, CtrlSquiggly has you covered. Upgrade your Excel game, impress your colleagues, and unlock your full potential with our smart yet fun approach to mastering Excel. www.ctrlsquiggly.com/coaching

Previous
Previous

Master Stock Price Tracking with Google Sheets

Next
Next

Unlock Student Success: Get a 3-Month Free Trial of Microsoft 365 Personal with AI-powered Copilot Features for College Students in the U.S.