Microsoft is officially retiring the current Exchange connector in Excel Power Query by April 2027, forcing users to manually migrate their workbook connections to maintain functionality. The transition will not be automatic, and users relying on older software will be locked out of the new connectors unless they upgrade to Microsoft 365 or Office 2024.
According to the timeline published in the Microsoft Message Center, the software giant is rolling out customer validation for the new Exchange Mail and Calendar connectors starting in August for early adopters. This precedes the final phase of the Exchange Web Services (EWS) retirement enforcement in Exchange Online, which is scheduled to begin in October.
The most significant hurdle for businesses is the lack of an automated transition path. Existing workbooks that rely on Exchange Mail and Calendar data will simply stop working when the current connector is pulled, requiring users to manually reconnect their data sources. Furthermore, Microsoft has not yet shared its plans for Contacts and Tasks, stating only that guidance for those specific scenarios will be provided separately.
How to Prepare for the Excel Exchange Connector Migration
Because the countdown to the EWS retirement is already ticking, IT administrators and power users must take proactive steps to prevent data pipelines from breaking. Microsoft has requested that administrators begin identifying users who actively rely on Exchange-connected workbooks.
- Audit Existing Workbooks: Locate all Excel files currently using Power Query to pull Mail or Calendar data from Exchange.
- Plan Software Upgrades: Ensure that all users requiring the new connectors are upgraded to either Microsoft 365 or Office 2024, as older perpetual licenses will not support the new infrastructure.
- Prepare for Manual Reconnection: Develop a validation plan to manually reconnect Mail and Calendar data sources once the new connector experience becomes broadly available.
The Hidden Cost of the EWS Retirement
This transition is more than just a routine backend update; it acts as a forced upgrade cycle for businesses still clinging to older, perpetual Office licenses. By restricting the new Exchange connectors exclusively to Microsoft 365 and Office 2024, Microsoft is effectively using the EWS retirement to push enterprise holdouts into its modern subscription or latest perpetual ecosystem.
The lack of an automated migration path is going to create a massive headache for IT departments. In many organizations, legacy Excel workbooks act as critical, undocumented infrastructure for reporting and data analysis. Tracking down which specific workbooks use the old Exchange connector before the April 2027 cutoff will require extensive auditing, and failing to do so will result in broken reports and disrupted workflows across departments.
