Excel suddenly began saving files on close without prompts

[Hawkdl2]

This is a new behavior I can't explain. I have no macros (that I am aware of), no add-ons, and am using workbooks that I've had for months. I often test changes to data or formulas to see what might happen then close the file without saving so no permanent changes are made. Now, when I close the file it automatically saves my changes without a prompt. How do I get it to revert to the more standard prompt asking if I want to save my changes?


Larry

 

[AFPathfinder]

I didn't realize there was that property for workbooks. I suppose you'd change it in all workbooks the same way you did in that one.

 

[Hawkdl2]

It seems MS recently "fixed" a problem with Office 365 that did not set autosave to "on" for cloud-stored files. The fix defaults the setting to "on" and there is no way to turn it off globally - it has to be turned off for each workbook, though once turned off it will remember that setting for that file. There's a little button on the upper right of the Excel window's page to turn on or off the "auto save" feature. VBE is not needed. This solves the problem. The autoupdatefrequency value seems to be unrelated and applies only to the auto recovery feature, that is independent of the auto save feature.

And, no. autoupdatefreq rejects 5, 1, 10 and a few other values I tried as "invalid property values".

Thanks for your help.

 

[Hawkdl2]

Neither did I until this afternoon.