How to Close All Excel Files at Once. When you're working on multiple spreadsheets at a time in Microsoft Excel, closing them all one by one is wasted time you could have spent on another task.

Create or open your file. If this is a new file you've just created and are saving it for the first time, proceed to Step 2. If you're re-saving an existing Excel document, navigate to its ...

2] Save the Excel workbook file on the Local Hard Drive. This is another workaround that you must surely try before following any complicated fix.

The procedure is in the downloadable .bas files, which you can import into the Personal.xlsb file’s Module 1. If you enter the code manually, don’t paste from this web page.

How to recover a saved Excel file with unsaved work. If Excel closes before you've had a chance to save the most recent changes to your file — but the workbook has already been saved at least ...