How to Stop Microsoft Mashup Container Loader from Locking Files
Question details
Users are unable to overwrite or save source files because they are kept open by the Microsoft Mashup Container Loader in Power Query.
- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Running background previews or updating queries in Excel Power Query.
- Observed behavior
- The background data loader process locks the source files, preventing the user from editing or saving changes to those files.
Ensure you have saved all your current work in Excel, as you may need to modify global query settings or forcefully end background tasks to release the file locks.
Disable Global Background Data Previews
Prevent Power Query from preemptively downloading data previews, which often triggers the file-locking issue.
By default, Power Query downloads data previews in the background to ensure smooth editing. Disabling this global setting stops the Mashup Container Loader from holding onto source files unnecessarily.
In Excel, go to the Data tab on the ribbon, click on 'Get Data', and select 'Query Options' from the dropdown menu.
In the Query Options dialog box, look under the 'Global' section on the left pane and click on 'Data Load'.
Under the 'Background Data' section, select 'Never allow data previews to download in the background', then click OK to apply the changes.
Disable Background Updating for Existing Queries
Turn off background refresh settings for specific existing queries to release active file locks.
Force End the Container Loader Process
Manually terminate the Microsoft Mashup Container Loader if the file is stuck and cannot be saved immediately.
Experience Lightweight Data Processing with WPS Office
If you frequently struggle with resource-heavy background processes like the Mashup Container Loader locking your files, consider switching to WPS Office. It provides a lightweight, fast, and highly compatible alternative for everyday spreadsheet management.
- 1. Download and Install: Visit the official WPS Office website and download the free installation package for your operating system.
- 2. Open Your Spreadsheets: Launch WPS Spreadsheet and click 'Open' to seamlessly load your existing data files.
- 3. Work Without Interruptions: Enjoy editing, saving, and analyzing your data without worrying about hidden background processes locking your files.
Frequently Asked Questions
What exactly is the Microsoft Mashup Container Loader?
It is a background component used by Power Query in Microsoft Excel and Power BI to evaluate data queries, load previews, and process transformations without freezing the main application interface.
Will disabling background data previews break my Power Query formulas?
No. Your queries and transformations will continue to work perfectly. Disabling this setting only means that data previews will load on-demand when you interact with them in the editor, rather than downloading preemptively.
Why do I see multiple Mashup Container processes in Task Manager?
Power Query often spawns multiple instances of the container loader to evaluate different queries simultaneously. This parallel processing speeds up data retrieval but can occasionally cause multiple file lock conflicts.
Can I prevent file locking without changing query settings?
File locking is inherent to how the Mashup Engine reads local files. Aside from changing background load settings, you can copy the source data to another location or use database connections instead of flat local files to avoid read/write conflicts.
