Fix Excel Freezing with a White Screen and High Power Usage
Question details
The user needs to troubleshoot Excel freezes and high reported power usage while processing large workbooks.

- 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.
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.
Reduce an unnecessarily expanded worksheet used range
Use this method when Excel treats cells far beyond the actual data as part of the worksheet.
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.
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.
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.
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.

Review workbook links, formulas, queries, and storage
Use these checks if the workbook remains slow after its used range has been cleaned.
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.

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.




