Power Query Problems

How to Fix Power Query Error 0xC00000BE in Excel

Nimra MalikNimra Malik Oct 10, 2026 870 views

Question details

The user needs to resolve error code 0xC00000BE (Container Unexpectedly Exited) which interrupts data queries.

How to Fix Power Query Error 0xC00000BE (Container Unexpectedly Exited)
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.
Before you start

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.

Solution 1Recommended

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.

1
Open Query Options

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.

2
Locate Data Load Settings

In the Query Options dialog box, look under the 'Global' section on the left sidebar and click on 'Data Load'.

3
Clear the Cache

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.

Clear the Power Query Cache
Tip: You can also try clearing the 'Clear Permissions' cache under Global > Data Source Settings if the issue persists.
Free Microsoft Office alternative

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. 1. Download and Install: Visit the official WPS website to download and install the free WPS Office suite on your device.
  2. 2. Open Your Workbooks: Launch WPS Spreadsheets and open your existing .xlsx files seamlessly without formatting loss.
  3. 3. Process Data Smoothly: Utilize the 'Data' tab in WPS Spreadsheets to sort, filter, and analyze your data without relying on external container dependencies.
Fully compatible with Microsoft Excel (.xlsx, .csv) formats for seamless file sharing.Lightweight architecture minimizes unexpected application crashes and container errors.Completely free to use with a familiar, easy-to-navigate user interface.Robust built-in data analysis tools that don't require complex tenant configurations.
microsoft office alternative - wps office

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.