Excel is not working efficiently

Question

Excel files close themselves while working and data is not saved

Answer 1

Hi Mohamed El-dalei,

I'm sorry to hear that Excel is closing unexpectedly while you're working. Since this can be caused by add-ins, Office components, or a specific workbook issue, here are a few additional checks that may help narrow down the cause:

1, Start Excel in Safe Mode

• Press Windows + R, type excel /safe and press Enter
• Open a workbook and test whether Excel remains stable

2, Disable Excel Add-ins

• Open Excel > File > Options > Add-ins
• At the bottom, select COM Add-ins > Go
• Uncheck all add-ins, restart Excel, and test again

3, Run an Office Repair

• Open Control Panel > Programs and Features
• Select Microsoft 365 > Change
• Run Quick Repair first

4, Check if the issue is workbook-specific

• Create a new blank workbook
• Enter some sample data and save periodically
• If the new workbook works normally, the issue may be related to a particular file

If the problem continues, please share more information on:

• Your Excel version and build number
• Whether the issue occurs with all workbooks or only specific files
• Any error message shown before Excel closes

Let me know if you need further assistance, feel free to ask me by clicking "Add Comment" or "Add Answer" if you cannot add comment so your response will be visible. Thanks for your effort.

---

Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

Answer 2

Try this in order:

1. Save the workbook to a local drive first If the file is on a network drive, SharePoint, Web folder, redirected Documents folder, Remote Desktop/Citrix session, or other virtualized/network location, save a copy locally and work from that copy. This helps determine whether the issue is the file itself or where it is stored.
2. Save to a different folder or drive Excel saves by creating a temporary file, deleting the original file, and then renaming the temporary file. If that process is interrupted, the workbook can close and changes may not be saved. Saving to an alternative drive or folder can avoid the interruption.
3. Check folder permissions The save location must allow:
   • Read
   • Write
   • Modify
   • Delete
   Missing any of these permissions can prevent Excel from completing the save process.
4. Check free disk space If the destination drive is low on space, Excel cannot complete the save operation.
5. Test antivirus interference Antivirus software can interrupt Excel while it is saving, especially because Excel creates a temporary file first. If antivirus is integrated with Excel or scans new files immediately, it can cause performance issues or failed saves. Important: Changing antivirus settings can make the PC more vulnerable to malicious attacks. Use caution. Actions to try:
   • Make sure the antivirus product is fully up to date.
   • Temporarily deactivate antivirus and test saving.
   • If the antivirus has Excel integration or Excel add-ins, disable that integration/add-in and test again.
6. Switch calculation to Manual if the workbook is complex Slow recalculation during open/save can make Excel appear unresponsive. In Excel:
   • Go to Formulas
   • Select Calculation Options
   • Choose Manual
7. Move out of Page Break Preview and test printer/video drivers Excel is printer-intensive and can run slower in Page Break Preview. Problems with the default printer or video driver can also contribute to hangs or crashes. Testing with a different printer such as Microsoft XPS Document Writer can help identify whether the issue is tied to the current printer driver.
8. Clean temporary files Too many temporary files can cause problems with opening, closing, and saving workbooks. In Windows:
   • Open Start > Run
   • Type %temp%
   • Select OK
   If a restart is pending after software installation, restart first before deleting temporary files.
9. Watch for file/path issues If the full path and file name exceed 218 characters, Excel may fail with Filename is not valid.
10. If the workbook closes unexpectedly before saving Excel may show errors such as:
    • Document not saved
    • Document not completely saved
    • Document not saved. Any previously saved copy has been deleted
    • The document is not saved
    In these cases, save the still-open workbook immediately to an alternative drive or folder if possible.

If the problem continues after these checks, contact Microsoft Support for guided troubleshooting.

---

• Excel not responding, hangs, freezes or stops working
• Troubleshoot why Excel doesn't save changes
• Excel performance: Tips for optimizing performance obstructions