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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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
Scott CSenior EngineerCommented:
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
Big Business Goals? Which KPIs Will Help You

The most successful MSPs rely on metrics – known as key performance indicators (KPIs) – for making informed decisions that help their businesses thrive, rather than just survive. This eBook provides an overview of the most important KPIs used by top MSPs.

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:
0

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows 10

From novice to tech pro — start learning today.