Excel suddenly entering non-responding mode and creating new sheets for every entry is typically caused by corrupted temporary files or conflicting add-ins. Clearing the Excel temp folder and disabling third-party extensions usually resolves this buffer issue immediately without requiring a full reinstall of the software.
Immediate Workaround: Safe Mode
Before diving into file cleanup, it is crucial to determine if the issue stems from your user profile or a specific workbook. The fastest way to isolate the problem is to launch Excel in Safe Mode. This starts the application with default settings and no add-ins loaded. To do this, hold down theCtrl key while clicking the Excel icon, or run excel.exe /safe from the command prompt. If Excel functions normally in this state, the culprit is likely an add-in or a corrupted template.
This diagnostic step helps distinguish between a global configuration error and a localized data corruption. If the problem persists even in Safe Mode, the issue may lie deeper within the installation or system resources. In such cases, you might also need to address startup failures, which can be found in our guide on how to fix Excel Won't Load Document on Double-Click.
Clearing Temporary Files
One of the most common causes of "Not Responding" errors is the accumulation of corrupted temporary files. Excel uses these files to store unsaved work and cache data during operations. When these files become fragmented or locked, the application can freeze or behave erratically, such as duplicating sheets unexpectedly. To clear these files safely, follow these steps:- Close all instances of Microsoft Excel completely.
- Press
Windows Key + Rto open the Run dialog box. - Type
%temp%and press Enter to open the temporary folder. - Delete all files that start with
~$or have the extension.tmp. - Additionally, check the folder
C:\Users\[YourUsername]\AppData\Local\Microsoft\Office\UnsavedFilesand remove any leftover drafts.
Disabling Add-ins
If clearing temp files did not solve the problem, third-party add-ins are the next most likely suspects. Add-ins can interfere with Excel's internal buffers, especially if they are outdated or incompatible with your current version of Office. They may trigger automatic actions, such as creating new sheets, when you input data. To disable add-ins:- Open Excel (preferably in Safe Mode if possible).
- Navigate to File > Options > Add-ins.
- At the bottom of the window, locate the Manage dropdown and select COM Add-ins.
- Click Go... and uncheck all listed add-ins.
- Restart Excel normally to see if the behavior returns to normal.
Repairing Office Installation
When standard troubleshooting fails, the core installation files may be corrupted. Microsoft provides a built-in repair tool that checks and fixes missing or damaged components without deleting your personal data. This is particularly useful if the "Not Responding" issue is accompanied by other glitches, such as inability to save or render errors. Access the repair feature through your operating system's settings:- Open Settings > Apps > Installed Apps (or Control Panel > Programs and Features).
- Find Microsoft Office or Microsoft 365 in the list.
- Select Modify and choose Quick Repair first.
- If the issue persists, repeat the process and select Online Repair, which performs a more thorough check.
Checking for Hardware Acceleration Issues
In some older versions of Excel, hardware acceleration can cause rendering bugs that manifest as freezing or non-responsive interfaces. While less common in recent updates, this setting can still cause buffer conflicts on systems with outdated graphics drivers. To adjust this setting:- Go to File > Options > Advanced.
- Scroll down to the Display section.
- Check the box for Disable hardware graphics acceleration.
- Restart Excel to apply the change.
Frequently Asked Questions
Why does Excel create a new sheet for every entry?
This behavior is usually triggered by a macro or add-in that automatically inserts rows or sheets upon data validation. Check your VBA project for event handlers like Worksheet_Change that might be firing incorrectly. Disabling macros via Safe Mode will confirm if this is the cause.
Is it safe to delete all files in the %temp% folder?
Yes, it is generally safe to delete contents of the %temp% folder, but you should close all applications first. Some files may be in use and cannot be deleted; simply skip those. Focus on Excel-specific temporary files marked with ~$ prefixes for best results.
How do I know if my Excel version is corrupted?
If you experience random crashes, missing ribbon tabs, or errors in basic functions like SUM, the installation may be corrupted. Running the Quick Repair tool from the Control Panel will verify integrity. Persistent issues after repair suggest a deeper OS-level conflict.
Can antivirus software cause Excel to freeze?
Yes, real-time scanning can lock temporary files Excel needs to write to, causing it to hang. Add Excel to your antivirus exclusion list or temporarily disable real-time protection to test. If performance improves, adjust your security settings to allow Excel processes uninterrupted access.
What should I do if Excel freezes during formula calculation?
Switch to manual calculation mode by going to Formulas > Calculation Options > Manual. This prevents Excel from recalculating every time you make an entry. You can then calculate manually using F9 once your data is complete. See Can/will anyone help me with a Formula for more optimization tips.