# Microsoft Retiring Excel Exchange Connector by April 2027

**Published:** 2026-08-26T07:50:20.323Z  
**Topic:** Microsoft  
**Sentiment:** neutral  
**Publisher:** TrendWatcher — https://www.trendwatcher.in/article/c528b0b3-7a7d-49cb-b0c1-5b0bd69c2060

Microsoft is phasing out the Excel Power Query Exchange connector. Users must migrate workflows before the April 1, 2027, shutdown of Exchange Web Services.

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].

| At a glance | |
|---|---|
| Affected Feature | Power Query Exchange Connector |
| Retirement Date | April 1, 2027 |
| Primary Driver | Exchange Web Services (EWS) Shutdown |
| Scope | Exchange Online and Microsoft 365 |

## 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].

## Sources
1. Forums — [Microsoft warns that transitioning Excel workbooks to new... | Forum](https://forums.theregister.com/forum/all/2026/08/25/202615/)
2. The Register — [Microsoft warns that transitioning Excel workbooks to new Exchange connectors might not be smooth sailing](https://www.theregister.com/software/2026/08/25/microsoft-warns-that-transitioning-excel-workbooks-to-new-exchange-connectors-might-not-be-smooth-sailing/5292316)
3. Windows Report — [Microsoft’s Excel Connector Retirement Could Break Your Workbooks](https://windowsreport.com/microsofts-excel-connector-retirement-could-break-your-workbooks/)
4. Windowsforum — [Excel Power Query Exchange Connector Fails After April 2027](https://windowsforum.com/windows-news.4/excel-power-query-exchange-connector-fails-after-april-2027.443493/)

---
Cite as: TrendWatcher, "Microsoft Retiring Excel Exchange Connector by April 2027", https://www.trendwatcher.in/article/c528b0b3-7a7d-49cb-b0c1-5b0bd69c2060