Fix Excel Crashing When Refreshing Queries on Windows
Question details
The user experiences severe system crashes and OutOfMemory exceptions when attempting to refresh multiple data queries simultaneously in a single Excel workbook.

- Product
- Microsoft 365 Excel (64-bit)
- Device & OS
- Windows (HP ZBook G9)
- Scenario
- Clicking 'Refresh All' on a 4.7 MB workbook containing approximately 100 Power Query data connections.
- Observed behavior
- CPU, memory, and SSD usage spike to 100%, while GPU usage remains near zero. This causes Excel to throw a System.OutOfMemoryException, the screen to flash black, or the computer to shut down entirely.
Ensure you save a backup copy of your 4.7 MB workbook before making any structural changes, and close all other background applications to free up maximum RAM for Excel.
Split the Data Queries into Smaller Workbooks
Dividing the queries across multiple files reduces the concurrent load on your system's memory and CPU during the refresh process.
When Excel attempts to refresh hundreds of complex queries simultaneously using 'Refresh All', it can easily exceed available continuous memory limits, even on high-end devices with 32GB of RAM. Segregating historical data or independent queries into separate workbooks prevents the System.OutOfMemoryException.
Open your main workbook and review your Power Query connections to determine which data tables (e.g., data from specific past years) can be isolated.
Create new blank Excel files and copy the respective data queries into these new files, grouping them logically by year or category.
In the original workbook, navigate to 'Data' > 'Queries & Connections', right-click, and delete the queries you have successfully moved to the new files.
Open each smaller workbook one at a time and click 'Refresh All' in the Data tab to update the data without overloading system resources.

Disable Background Refresh to Prevent Overload
Forcing Excel to wait for one query to finish before starting another can sometimes mitigate massive memory spikes.
Use WPS Office for Lightweight Spreadsheet Management
If Microsoft Excel continues to struggle with heavy memory usage, calculation bottlenecks, and performance crashes on your device, consider switching to WPS Office. It provides a lightweight alternative that handles large datasets smoothly without aggressively draining system resources.
- 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and follow the quick installation prompts.
- 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbooks directly without any format conversion.
- 3. Analyze Data Smoothly: Enjoy a lighter footprint on your system memory while managing complex data, formulas, and charts.

Frequently Asked Questions
Why is my GPU usage at zero when Excel crashes?
Microsoft Excel and Power Query primarily rely on the CPU and system RAM to process data connections and calculate formulas. Hardware acceleration in Excel is generally limited to rendering the user interface and graphics, which is why your NVIDIA GPU remains inactive during intensive data refreshes.
What does System.OutOfMemoryException mean in a 64-bit Excel?
Even in 64-bit Excel, this error occurs when the application attempts to process a massive workload (like refreshing 100 queries at once) that exceeds the continuous memory blocks it can allocate, causing the engine to fail despite having 32 GB of physical RAM available.
Can I improve 'Refresh All' speed without splitting files?
You can optimize your Power Query steps by applying filters early, removing unnecessary columns before merging, and disabling 'Background Refresh' in the Connection Properties. This reduces the memory footprint during execution.
Why does my entire laptop shut down during an Excel refresh?
When CPU, memory, and SSD usage hit 100% simultaneously, it can trigger thermal throttling or a hardware safeguard on the laptop, leading to a sudden shutdown to protect internal components from overheating.




