Excel Performance Problems

Fix Excel Crashing When Refreshing Queries on Windows

Bushra ParveenBushra Parveen Oct 22, 2026 869 views

Question details

The user experiences severe system crashes and OutOfMemory exceptions when attempting to refresh multiple data queries simultaneously in a single Excel workbook.

How to Fix Excel Crashing When Refreshing Queries
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.
Before you start

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.

Solution 1Recommended

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.

1
Identify independent query groups

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.

2
Create separate workbooks

Create new blank Excel files and copy the respective data queries into these new files, grouping them logically by year or category.

3
Delete migrated queries from the main file

In the original workbook, navigate to 'Data' > 'Queries & Connections', right-click, and delete the queries you have successfully moved to the new files.

4
Refresh individually

Open each smaller workbook one at a time and click 'Refresh All' in the Data tab to update the data without overloading system resources.

Split the Data Queries into Smaller Workbooks
Performance Boost: This method dramatically lowers peak CPU and memory usage, ensuring stable data updates and preventing system crashes.
Free Microsoft Office alternative

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. 1. Download and Install WPS Office: Visit the official WPS website to download the free suite and follow the quick installation prompts.
  2. 2. Open Your Excel File: Launch WPS Spreadsheet and open your existing .xlsx workbooks directly without any format conversion.
  3. 3. Analyze Data Smoothly: Enjoy a lighter footprint on your system memory while managing complex data, formulas, and charts.
Highly compatible with Microsoft Excel (.xlsx, .xls, .csv) formats without data loss.Lightweight installation with significantly lower RAM and CPU consumption.Familiar tabbed user interface ensuring a seamless migration for Excel users.Stable performance during heavy calculations and data processing.
microsoft office alternative - wps office

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.