Excel Performance Problems

Fix Excel Freezing with a White Screen and High Power Usage

Khadija KhanKhadija Khan Nov 18, 2026 870 views

Question details

The user needs to troubleshoot Excel freezes and high reported power usage while processing large workbooks.

Fix Excel Freezing with a White Screen and High Power Usage
Product
Microsoft Excel
Device & OS
not provided
Scenario
Workbooks process large data ranges, Access queries, VLOOKUP formulas, and SUMIF calculations.
Observed behavior
Excel displays a white screen and freezes, and Outlook sometimes freezes as well. Task Manager may report high power usage even when CPU and memory readings appear normal.
Before you start

Identify the affected workbook and note where its actual data ends on each worksheet. Check whether it contains external links, Access queries, or formulas that depend on large ranges.

Solution 1Recommended

Reduce an unnecessarily expanded worksheet used range

Use this method when Excel treats cells far beyond the actual data as part of the worksheet.

1
Check the last used cell

Open the affected workbook, select a worksheet, and press Ctrl+End. Compare the selected cell with the actual last row and column containing data or formulas.

2
Remove unused rows

If the used range extends below the real data, select the first entirely unused row through the bottom of the sheet, then use Home > Delete > Delete Sheet Rows. Confirm that the selected rows contain no needed data, formulas, or formatting.

3
Remove unused columns

Select the first entirely unused column to the right of the real data through the end of the sheet, then use Home > Delete > Delete Sheet Columns. Repeat the checks on other affected worksheets.

4
Save and recheck

Use File > Save As to save a cleaned copy, close it, and reopen it. Press Ctrl+End again on each cleaned worksheet, then test the operations that previously caused a freeze.

Reduce an unnecessarily expanded worksheet used range
Check before deleting: Hidden cells and formatting may be intentional. Review the selected rows and columns before deleting them; Ctrl+End alone does not prove they are unnecessary.
Free Microsoft Office alternative

Try WPS Spreadsheets as an Excel Alternative

WPS Office is a free, lightweight, easy-to-use alternative with a familiar spreadsheet interface. Open compatible Excel workbooks in WPS Spreadsheets for a smooth transition, although it does not repair Microsoft Excel itself.

Open and edit spreadsheets in a familiar interfaceCompatible with common Microsoft Excel formats, including XLS and XLSXReview large worksheet ranges and formulas in an alternative spreadsheet appFree and lightweight office suite
microsoft office alternative - wps office

Frequently Asked Questions

Why does Ctrl+End take me far beyond my Excel data?

Excel may consider previously edited or formatted cells part of the used range. Check the rows and columns beyond your actual data, delete those that are truly unused, save the workbook, and reopen it.

Does high power usage mean Excel is using too much CPU?

Not necessarily. Task Manager's power usage indicator is separate from the current CPU and memory readings. Investigate workbook calculations, queries, links, and storage rather than relying on that indicator alone.

How can I find external workbook links?

In Excel, open Data > Workbook Links or Data > Edit Links, depending on your version. Review each source before removing or breaking a link, because breaking it can replace linked formulas with values.

Should I switch Excel to manual calculation?

You can use Formulas > Calculation Options > Manual as a troubleshooting test and press F9 to recalculate. Restore Automatic if you need formulas to update automatically.

Is OneDrive always responsible for these freezes?

No. The workbook may not use OneDrive at all. If it is stored on a network location, compare performance with a local copy using File > Save As.