Excel closes without saving changes

Rob Rudloff
Rob Rudloff used Ask the Experts™
on
Hi.  All of a sudden, Excel is allowing me to close it without saving changes I've made.  So, if I make a change, and click the red X to close Excel, Excel does not prompt me to save my changes -- it just closes.   See video at HERE.

I uninstalled/reinstalled all of Office 2106 (this is an Office365 subscription), but that didn't fix it.

Any suggestions?
Thanks!
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
RaminTechnical Advisor

Commented:
Repair Office and verify the status.  to do so go to  Control Panel > Programs >  Programs and Features > Select the Office suite installed > Click on Change > Repair > Continue.  Try Quick repair first and if it didn't help try Complete repair.
RaminTechnical Advisor

Commented:
Does the workbook contain a macro?
Scott CSenior Engineer

Commented:
Couple things come to mind....any macros?  Probably not as you uninstalled and re-installed.

Check for virus/malware.

Do you see this if you open a new spreadsheet add some text then click on the red x?
How to Generate Services Revenue the Easiest Way

This Tuesday! Learn key insights about modern cyber protection services & gain practical strategies to skyrocket business:

- What it takes to build a cloud service portfolio
- How to determine which services will help your unique business grow
- Various use-cases and examples

Rob RudloffIT Development Specialist

Author

Commented:
Previous to reinstalling Office, I did the various repairs, and just tried again (just to be sure) -- No change.
There are no macros in the workbook -- As in the video, even if you open a new, blank workbook, the same problem occurs.  

This just issue started a week or so ago.  (So, before anyone asks -- I did not do the recent Windows 10 update to .1709)

--- thanks
RaminTechnical Advisor

Commented:
Try starting Excel in safe mode and see if it continues,

start>run> excel /safe
RaminTechnical Advisor

Commented:
How about creating a new User Account in Windows and retest.
Did you Try Windows System Restore ?

Make sure you have installed all security Updates.
https://support.office.com/en-us/article/Outlook-known-issues-in-the-June-2017-security-updates-3F6DBFFD-8505-492D-B19F-B3B89369ED9B
Rob RudloffIT Development Specialist

Author

Commented:
Ok ... interesting ...  
In  SAFE MODE, Excel does not have the problem.  It prompts me to save my changes, as it should.

Also, I noticed that in "regular" mode, when I clock the red "X" to close Excel, it takes a while for it to close -- the cursor spins for a few seconds, then excel closes. But, this does not happen in SAFE mode -- Once I click the "X", I get the prompt immediately, click "Don't Save", and it closes Excel immediately.
RaminTechnical Advisor

Commented:
If none of the above fixed the issue then try to repair Excel from below link:
https://support.office.com/en-us/article/Repair-an-Office-application-7821d4b6-7c1d-4205-aa0e-a6b40c5bb88b
Rob RudloffIT Development Specialist
Commented:
OK, In the end, here's what fixed it:

As suggested, I went to remove the Excel Add-ins.   In the end, it was the COM add-ins causing the issue.

In Excel, under File, select "Options", then the "Add-ins" tab.  At the bottom of that form, in the "Manage" drop-down box, I selected "COM Add-ins".   There were 3 or 4 add-ins there, so I unchecked them all, and clicked "OK".   That fixed this issue immediately.

I did enable each COM Add-in and test, to see which one was the culprit, and it seemed as if all of them were the culprit, individually.

Thanks for your help!
Rob
Rob RudloffIT Development Specialist

Author

Commented:
Thanks again!
RaminTechnical Advisor

Commented:
Thanks for your feedback and I'm glad I could help.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial