Excel 2016 freezing at the 100% loading screen is typically caused by corrupted startup files, problematic add-ins, or a damaged Office installation. The most effective immediate fix involves launching Excel in Safe Mode to bypass third-party extensions that often cause this specific hang. If Safe Mode works, you can isolate and disable the offending add-in.
Launch Excel in Safe Mode
The primary diagnostic step for an application stuck at 100% is to start it without loading any user-specific configurations or external plugins. This isolates whether the issue lies with the core application or with something added on top of it. To do this, hold down the
Ctrl key while clicking the Excel icon. Continue holding
Ctrl until prompted to confirm starting in Safe Mode. Select
Yes. If the workbook opens successfully in this mode, the problem is definitely related to an add-in or a corrupted template file.
Disable Problematic Add-ins
Once confirmed that Safe Mode resolves the issue, you need to identify which component is causing the freeze. Navigate to
File >
Options >
Add-ins. At the bottom of the dialog, look for the
Manage dropdown and select
COM Add-ins, then click
Go. Uncheck all listed items and click
OK. Restart Excel normally to see if the 100% hang persists. If it does not, re-enable add-ins one by one to find the culprit. Common offenders include PDF converters, financial data tools, or legacy integration plugins. For users dealing with other access issues, such as those found in our guide on
Excel Stuck: Unable to Open Password-Protected Sheet (0%), similar isolation techniques apply.
Repair the Office Installation
If Safe Mode does not help, the Office suite itself may be corrupted. Microsoft provides a built-in repair tool that fixes missing or damaged files without affecting your documents. Go to
Control Panel >
Programs and Features. Locate
Microsoft Office Professional Plus 2016 (or similar variant) in the list. Right-click it and choose
Change. You will see two options:
Quick Repair and
Online Repair. Start with Quick Repair, which takes only a few minutes. If the problem remains, run Online Repair, which reinstalls Office components from the internet but takes longer.
Clear Temporary Files and Templates
Corrupted temporary files or the default template
Normal.dotm can also cause Excel to hang indefinitely during startup. Close Excel completely. Press
Win + R, type
%appdata%\microsoft\templates, and press Enter. Delete the
Normal.dotm file here. Next, open another Run dialog and type
%temp%. Delete all files inside this folder. These steps force Excel to recreate fresh configuration files upon next launch. This method is particularly useful when standard troubleshooting fails.
Check for Conflicting Software
Sometimes, security software or cloud storage sync clients interfere with Excel’s startup process. Antivirus programs might scan every file Excel tries to load, causing a delay that appears as a freeze. Temporarily disable real-time protection to test this hypothesis. Additionally, ensure OneDrive or Dropbox is not actively syncing large workbooks when you attempt to open Excel. If you are working with CSV files that have formatting issues, refer to
Exploring Excel-like Formatting Functionalities in Opening CSV Files for related compatibility insights.
Frequently Asked Questions
Why does Excel freeze only sometimes?
Intermittent freezes are usually caused by network-dependent add-ins or cloud synchronization delays. If the hang occurs only when opening specific files, the issue likely lies within that workbook’s macros or links rather than the application itself.
Can I recover my unsaved work if Excel hangs?
Yes, Excel automatically saves recovery information. Go to
File >
Info >
Manage Workbook >
Recover Unsaved Workbooks. Look for recent versions that match the time you were working before the freeze occurred.
What if Safe Mode crashes immediately?
If Excel crashes even in Safe Mode, the installation is severely corrupted. You should uninstall Office completely using the Microsoft Support and Recovery Assistant (SaRA), then reinstall it from the Office portal.
Does disabling hardware graphics acceleration help?
It can, especially on older systems. Go to
File >
Options >
Advanced and check
Disable hardware graphics acceleration. This reduces strain on the GPU during rendering, which can prevent hangs during complex sheet loads.
Is there a registry fix for this issue?
While registry edits exist, they are risky and rarely necessary. Stick to the repair tool and add-in disabling first. Only modify the registry if explicitly advised by Microsoft Support after exhausting standard solutions.