To address the issue of Excel reopening a previously opened file after a crash, you can try the following steps:
- Disable Auto-recovery: This feature may be causing Excel to reopen the last files that were open during the crash. To disable it:
- Open Excel.
- Go to File > Options.
- In the Save category, uncheck the option for Save AutoRecover information every X minutes.
- Open Excel in Safe Mode: This can help you open Excel without loading the last session files. To do this:
- Press
Windows + Rto open the Run dialog. - Type
excel /safeand press Enter. This will start Excel in Safe Mode, allowing you to open only the file you want.
- Press
- Clear the Recent Files List: If the problematic file is in your recent files list, you can clear it:
- Go to File > Open > Recent.
- At the bottom, click on Clear unpinned items to remove the recent files.
- Repair Office: If you suspect that the file causing the crash is corrupted, repairing Office might help:
- Go to Control Panel > Programs > Programs and Features.
- Select Microsoft Office and click on Change. Choose Repair and follow the prompts.
By following these steps, you should be able to open only the specific file you want without Excel automatically reopening the other file that was causing issues.
References:
- Troubleshoot opening a blank screen when you double-click a file icon or file name in Excel
- The document caused a serious error the last time it was opened
- The file is already open
- To Create a Reader and Open a File
- Troubleshoot opening a blank screen when you double-click a file icon or file name in Excel