One of the scenarios users cannot work with Microsoft Excel is that "Excel 2016 opens and closes immediately". If your Excel shuts down immediately after opening on a PC, it indicates an Excel crash issue. To prevent the constant Excel flashing problem from happening all over again, you should follow the article's tips to trace the causes and apply the five most effective solutions to reopen Excel in order to create a new workbook as usual.
Workable Solutions | Step-by-step Troubleshooting |
---|---|
Fix 1. Open Excel in Safe Mode | Press and hold the Ctrl key and double-click...Full steps |
Fix 2. Repair MS Office | Press Windows +R keys and type appwiz.cpl...Full steps |
Fix 3. Remove Conflicting Apps | Press Windows + R keys to bring up the Run...Full steps |
Fix 4. Install Lastest Updates | Open the Microsoft Store app by typing...Full steps |
What causes Excel not opening ,flashing up and disappearing:
If you're regular users who know little about any corruption related to hardware or software, and those background processing apps that might be the cause of the Excel not opening on a normal basis, do not struggle to learn the intricate theories. All you need to do is follow the below troubleshooting guides each by each until the trouble has been finally solved, and Excel can open again on your computer.
A quick tip for you - Make sure that you've tried to restart your computer, which solves most common system and application issues, before proceeding with the five fixing methods behind.
How Does An Excel File Get Corrupted?
Cannot open an Excel workbook due to file corruption? How does an Excel file get corrupted? Can you recover a corrupted Excel file in Windows 10?
By Microsoft: "Starting a Microsoft Office for Windows application in Office Safe Mode can allow you to safely use it when it has encountered certain problems. This is useful when you need to open a file that you can't under normal mode because the application is crashing or if you need help in identifying an add-in or extension that may be causing a problem on startup."
The method works for most Office version on a Window PC, including Excel 2016.
The othe way to open Excel in Safe Mode is via the Run box:
If you can't start the Excel 2016 application in Office Safe Mode, or if the unexpectedly open and shut down problem is recurring after exiting Safe Mode, you can try to repair or reinstall the MS Office in this way.
Chances are that when you boot the system, many startup programs and processes are auotmatically executing in the background, and some happen to conflict with your Excel 2016 program. So, we should find the suspecious ones, and simply stop them from running with your Excel application.
This is where you can update Office and you computer
Though it's suggested to set Windows Update to automatically download and install recommended updates, many people neglect the suggestion and finally encounter the open and close issue in Office. Installing an important and optimal updates can replace out-of-date files and fix vulnerabilities.
Since you have problems in opening the Excel 2016, it's impossible to get the update wihin the application. Instead, you can get the update in the Microsoft Store where you purchased Office.
The above four fixing methods are exclusively for correcting the problem of Excel 2016 not opening, or Excel 2016 shutting down itself immediately after opening on a Windows PC. If your concern is more related to Excel file recovery, go on with the last part.
How to Fix Excel File Keeps Closing Automatically
If your Microsoft Excel file keeps closing automatically while editing, it probably because Excel has a crash problem. Here, you can get 5 fixes to get rid of the issue...
Data loss is the most direct consequence brought by Excel closing immediately after opening. Have you lost a workbook file due to an automatic shutdown of Excel? How to recover unsaved Excel file in Windows 10/8.1/8/7? The below table offers you many useful links about Excel file recovery in different scenarios.
Scenarios | Contents | Get Solutions |
Excel Overwritten and Replaced | While editing documents, it is common to accidentally saved over a Word document or an Excel and lose important content... | Read More |
Excel Password Protected | Did you forget or lose your password to unlock your password protection Excel files? Relax! Here, we cover the five most useful online Excel password remover tools... | Read More |
Excel Worksheet Deleted | Did you accidentally delete a worksheet in Excel? This page shows you how to recover deleted sheet in Excel before or after saving without losing any change | Read More |
Excel Runtime Error | How to Fix Runtime Error 1004 in Excel? There are four effective methods for you to choose from | Read More |
When you read those linked pages, you'll find that the solutions to the Excel file recovery in complex scenarios are not unique. We have to try multiple methods one by one and even again and again to save a damaged file due to the Excel program crashing or freezing problem. And one thing in common is that, whenever your lost an Office file (Word doc/docx, Excel xls/xlsx or Powerpowert ppt/pptx) due to a deletion, disk formatting or virus infection, you can merely use third-part file recovery software to achieve a complete recovery with ease.
Deep Data Recovery is the top one data recovery software reviewed by authorative websites and real customers. It's easy-to-use yet powerful in scanning various physical storage devices for lost data of over 1000 file types. One salient feature distinguishing Qiling file recovery software from rivals is that it can also repair a corrupted Excel file that cannot open after recovery.
The overall steps of recovering a deleted, formatted or lost Excel file is outlined as following:
Step 1. Select file types and click "Next" to start
Launch Deep Data Recovery on your PC. Select file types and click "Next" to start.
Step 2. Select location and click "Scan"
Choose the drive or a specific folder on Desktop or somewhere else where you lost the excel files, and click the "Scan" button.
Step 3. Locate your excel files
To quickly find the Excel files from the scan results, click the "Documents" option in the left panel. Choose "Excel", and click "Preview" to check if the Excel files are the wanted ones.
Step 4. Recover Excel files
Finally, select the desired Excel files and click the "Recover" button. Then, select a folder to save the Excel files to another location.