Apr 20 2021 05:03 AM
Hy,
when i close an excel-workbook there doesn't come the Question: "Do you want to save?" Can i activate this?
Greetings
Andreas
Apr 20 2021 05:23 AM
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.
Apr 20 2021 02:16 PM
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.
Apr 20 2021 03:02 PM
That is strange. See if Tina Chen's reply in Excel not asking if I want to save changes helps.
Apr 20 2021 06:12 PM
SolutionApr 21 2021 03:28 PM
Apr 21 2021 03:31 PM
Apr 22 2021 10:13 AM
Apr 20 2021 06:12 PM
Solution