Excel closed without asking me for saving

Question

Hi, I have an issue with excel it happened several times the Excel file is closed without asking me if I want to save or not

it like I never opened the file

could you please help

Answer 1

Hi Lenglin

Software add-ins may cause Excel 2016 app not to prompt saving on exit. To isolate the issue, try opening Excel in safe mode.

1. Find the shortcut icon for Excel application on the Taskbar.
2. Press and hold the CTRL key and double-click the application shortcut
3. Click Yes when a window appears asking if you want to start the application in Safe Mode.

Once you start Excel in safe mode, you’ll see Safe mode on the title, as shown below:

Make some changes in workbook, check if you get the save prompt when exiting the workbook.

Note*: To stop Office Safe Mode, exit and restart your Office application. It will start in normal mode unless there's a problem opening the application.*

Additionally, try disabling the add-ins for the application and check the result:

1. In the Excel application create a new workbook, click File > Options > Add-Ins.
2. At the bottom of the dialog box, change the Manage dropdown to COM add-ins, and select Go.
3. Clear the checkbox for any enabled COM add-ins. select OK.

If the issue persists, please provide the following information:

1. Please provide the screenshot of Office 2016 Product Information. To get this screenshot, open OneNote 2016 on your system, click File>Account, capture the screenshot of all the information mentioned under Product Information.
2. Create a new workbook, check if same thing happens.
3. Check your VBA modules (regular and workbook) to see if any VBA Close event is changing this behavior.
4. Is any other Office application not giving the prompt when closing?

Thanks,

Neha

Answer 2

Hi Lenglin

Did you check the above reply? Please update us when you have time.

Regards,

Neha