Second time in one hour Excel closes itself

Copper Contributor

Trying to do some work in a spreadsheet today and when I got up from my PC and came back not 20 minutes later I noticed Excel was no longer open. I started it up again and got a document recovery window and was able to recover a newer version that had most my updates. 

 

Still working and as I'm about to update a cell I watch the program close with the animation and all, as if it had some sort of command to do so. I go to open Excel again and I am met with a Microsoft Office update. I'm thinking there's something to do with office force pushing updates (even though in the account tab they are marked "This product will not be updated"). After this update I was not able to recover any work since the last crash with Auto Recovery

 

It's obvious that Auto Recovery is not saving information every 1 minutes like it is set to. How can I prevent these random closures, or at the very least get my Auto Recovery to work as intended.

 

No add-ons installed.

 

Microsoft® Excel® for Microsoft 365 MSO (Version 2311 Build 16.0.17029.20028) 64-bit

 

1 Reply

@TrevorOlshefke 

Experiencing frequent crashes in Excel can be frustrating, but there are several steps you can take to troubleshoot and potentially resolve the issue:

1. Update Excel:

  • Ensure that your Excel application is up to date. Sometimes, updates include fixes for known issues. You mentioned an update occurred during your session, but it's good to confirm you're on the latest version.

2. Check Event Viewer:

  • Look for any error messages or events related to Excel crashes in the Windows Event Viewer. This might provide more detailed information about the cause of the crashes.

3. Disable Hardware Graphics Acceleration:

  • Open Excel and go to "File" > "Options."
  • Under the "Advanced" tab, look for the "Display" section.
  • Check the box that says "Disable hardware graphics acceleration."
  • Click "OK" and restart Excel.

4. Safe Mode:

  • Try running Excel in Safe Mode to rule out any potential conflicts with add-ins or extensions. To do this:
    • Press Win + R to open the Run dialog.
    • Type excel /safe and press Enter.
  • If the issue doesn't occur in Safe Mode, it might be related to an add-in or extension.

5. Check AutoSave and AutoRecover Settings:

  • Go to "File" > "Options" > "Save."
  • Verify that both AutoSave and AutoRecover are enabled and set to a reasonable frequency.
  • Adjust the settings if necessary.

6. Repair Office Installation:

  • You can repair your Office installation through the Control Panel:
    • Go to "Control Panel" > "Programs" > "Programs and Features."
    • Find Microsoft 365 (or Office) in the list, select it, and choose "Change."
    • Select "Quick Repair" and follow the on-screen instructions.

7. Check for Conflicting Updates:

  • Sometimes, updates from other applications or the operating system can conflict with Office updates. Ensure that your Windows operating system is also up to date.

8. Disable Add-Ins:

  • While you mentioned no add-ons are installed, it's worth double-checking. Go to "File" > "Options" > "Add-Ins" and disable any add-ins, even if they seem unrelated to Excel.

9. Create a New Profile:

  • If the issue persists, you might try creating a new Windows user profile and see if Excel behaves normally there. This can help identify whether the problem is user-specific.

Remember to save your work frequently, and consider making manual backups to avoid data loss during unexpected closures. The text and steps were edited with the help of AI.

 

My answers are voluntary and without guarantee!

 

Hope this will help you.

Was the answer useful? Mark as best response and Like it!

This will help all forum participants.