How to Fix Power Query Error 0xC00000BE in Excel
Question details
The user needs to resolve error code 0xC00000BE (Container Unexpectedly Exited) which interrupts data queries.

- Product
- Microsoft Excel / Microsoft 365
- Device & OS
- not provided
- Scenario
- Refreshing data queries using Power Query in Excel or Microsoft 365.
- Observed behavior
- The query refresh fails and returns the error 'Container Unexpectedly Exited, Code 0xC00000BE', preventing the data from updating.
Ensure that your Microsoft 365 applications are fully updated to the latest version and save a backup copy of your workbook before modifying query settings.
Clear the Power Query Cache
Clearing the local data cache forces Excel to retrieve fresh data and can resolve unexpected container crashes.
Power Query stores temporary data to speed up future queries. If this cache becomes corrupted, it can cause the mashup container to exit unexpectedly during a refresh.
Launch Excel and open your workbook. Go to the 'Data' tab on the ribbon, click on 'Get Data', and select 'Query Options' at the bottom of the drop-down menu.
In the Query Options dialog box, look under the 'Global' section on the left sidebar and click on 'Data Load'.
Under the 'Data Cache Management Options' section, click the 'Clear Cache' button. Click 'OK' to apply the changes, then attempt to refresh your query again.

Escalate to Microsoft 365 Administrator
If local troubleshooting fails, the issue may stem from organizational environment restrictions or Microsoft 365 tenant configurations.
Switch to WPS Office for Streamlined Spreadsheet Management
If you frequently encounter complex environment errors like 0xC00000BE in Microsoft 365, consider switching to WPS Office. It offers a lightweight, highly compatible alternative for data processing and everyday spreadsheet tasks without the heavy resource dependencies.
- 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
- 2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files seamlessly without formatting loss.
- 3. Process Data Smoothly: Utilize the 'Data' tab in WPS Spreadsheets to sort, filter, and analyze your data without relying on external container dependencies.

Frequently Asked Questions
What causes the Power Query error 0xC00000BE?
This error generally occurs when the underlying mashup container (the engine processing the data) crashes. It can be caused by a corrupted local cache, insufficient device memory, or complex organizational environment configurations within Microsoft 365.
Will reinstalling Excel fix the container unexpectedly exited error?
Reinstalling or repairing Microsoft 365 can sometimes resolve corrupted installation files causing the error. However, it is highly recommended to clear your Power Query cache and check for Windows updates first, as the issue is often related to data caching or tenant-level restrictions.
Does error 0xC00000BE mean my data is permanently lost?
No. Power Query connects to and transforms external data sources rather than storing the original data. Your source data remains perfectly safe; you simply need to resolve the query connection issue to successfully import the refreshed data into your workbook.




