Microsoft Retiring Excel Exchange Connector by April 2027

Excel workbooks relying on the Power Query Exchange connector to pull mailbox or calendar data will stop functioning by April 1, 2027, as Microsoft completes its multi-year retirement of Exchange Web Services (EWS) [4]. This transition forces organizations to manually migrate reporting workflows that currently depend on the legacy API to avoid broken data refreshes [4].

The impact of the EWS shutdown

The upcoming failure of these connectors is a direct consequence of Microsoft’s broader effort to deprecate EWS, an API the company has been phasing out since 2018 [4]. While the service will be progressively disabled for Exchange Online organizations starting October 1, 2026, the final enforcement date is set for April 1, 2027 [4]. After this point, the Exchange connector will remain visible in the Excel "Get Data" menu, but any attempt to refresh queries will return errors [4].

The change specifically targets cloud-based environments, including Microsoft 365 and Exchange Online [4]. On-premises Exchange Server deployments are not subject to this specific retirement and will retain EWS functionality [4]. Because the dependency is embedded within the query connection rather than the workbook file itself, many users may not realize their dashboards or automated reports are at risk until a scheduled refresh fails [4].

Identifying at-risk workflows

The retirement does not affect standard Excel operations such as PivotTables, formulas, or CSV imports [4]. Instead, it impacts a specific category of files that use the Exchange.Contents function to pull data from mailboxes, folders, or calendars [4]. Microsoft has begun the process of customer validation for replacement connectors as of August 2026, though the company’s public documentation currently continues to present the existing Exchange connector as a generally available source [4].

What to watch

• October 1, 2026: The date when Microsoft begins the progressive disabling of EWS for Exchange Online organizations [4].
• Replacement Connector Rollout: Monitor Microsoft’s Message Center for the release of updated, non-EWS dependent connectors to replace existing Power Query workflows [1].
• Hybrid Environment Audits: Organizations running hybrid setups should verify whether their specific data sources are cloud-hosted, as these will require migration even if the local server remains on-premises [4].

The shift highlights the fragility of relying on legacy APIs for automated business reporting. While the deadline is months away, the lack of clarity in current documentation suggests that many automated help-desk or compliance dashboards may face unexpected downtime if not manually reconfigured before the spring of 2027 [4].