Excel closes without saving changes

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!
Rob RudloffIT Development SpecialistAsked:
Who is Participating?
 
RaminTechnical AdvisorCommented:
0
 
RaminTechnical AdvisorCommented:
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.
0
 
RaminTechnical AdvisorCommented:
Does the workbook contain a macro?
0
Ultimate Tool Kit for Technology Solution Provider

Broken down into practical pointers and step-by-step instructions, the IT Service Excellence Tool Kit delivers expert advice for technology solution providers. Get your free copy now.

 
Scott CSenior Systems EnginerCommented:
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?
0
 
Rob RudloffIT Development SpecialistAuthor 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
0
 
RaminTechnical AdvisorCommented:
Try starting Excel in safe mode and see if it continues,

start>run> excel /safe
0
 
RaminTechnical AdvisorCommented:
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
0
 
Rob RudloffIT Development SpecialistAuthor 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.
0
 
RaminTechnical AdvisorCommented:
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
0
 
Rob RudloffIT Development SpecialistAuthor 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
1
 
Rob RudloffIT Development SpecialistAuthor Commented:
Thanks again!
1
 
RaminTechnical AdvisorCommented:
Thanks for your feedback and I'm glad I could help.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.