SOLVED

close workbooks

%3CLINGO-SUB%20id%3D%22lingo-sub-2278895%22%20slang%3D%22de-DE%22%3Eclose%20workbooks%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2278895%22%20slang%3D%22de-DE%22%3E%3CP%3EHy%2C%20%3CBR%20%2F%3E%20when%20i%20close%20an%20excel-workbook%20there%20doesn't%20come%20the%20Question%3A%20%22Do%20you%20want%20to%20save%3F%22%20Can%20i%20activate%20this%3F%3C%2FP%3E%3CP%3EGreetings%3C%2FP%3E%3CP%3EAndreas%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2278895%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
New Contributor

Hy,
when i close an excel-workbook there doesn't come the Question: "Do you want to save?" Can i activate this?

Greetings

Andreas

7 Replies

@Aweham 

You should only get the prompt if the workbook has been modified, of course.

Are you using Excel Online? It saves workbooks automatically.

 

If you are on Windows or MacOS: could you have run a macro that disables events? If so:

Press Alt+F11 to activate the Visual Basic Editor.

Press Ctrl+G to activate the Immediate window.

Type

 

Application.EnableEvents = True

 

and press Enter.

Switch back to Excel.

@Hans Vogelaar 

Thank you, but it doesn't work.

 

I work with a notebook, windows 10 and Microsoft 365. I save local.

 

If I make a new workbook, save it - then comes the question.

But if i open it again, change something and close, then doesn't come the question and the change is lost.

 

@Aweham 

That is strange. See if Tina Chen's reply in Excel not asking if I want to save changes helps.

best response confirmed by Aweham (New Contributor)
Solution
Could you have some vba code that disables alerts? Using the same instructions as Hans gave you, open the immediate window and see what the current setting is:

?Application.DisplayAlerts

And you can try turning it back on with:
Application.DisplayAlerts = True
Sorry. I clicked wrong. It doesn't work.
?Application.DisplayAlerts says true!
Thank you. Nice Advice, but doesn't solve my problem.
I will phone with microsoft.

Greetings

Andreas
Personally, the only things I know that affect that behavior is the Application.DisplayAlerts property and the workbook's saved property (when you make changes, the saved property is set to false and excel will ask if you want to save changes upon exit; after saving, it is set to true).

You could enter this in the immediate window and check the saved property:
?Thisworkbook.saved
to see if excel is changing it as expected. But, if Excel's not changing it as it should automatically, then the only thing I could suggest would be to try re-installing office (which you might consider trying regardless).