It can be enabled manually with tools - autosave and then clicking the appropriate radio buttons. But you have to remember to do it, and it lasts only until you quit Excel. Is there a way of having it turned on permanently, or of enabling it by using VBA? I tried recording a macro but it gave me just an empty sheet. I guess it's not encouraged - at least by Microsoft - owing to the danger of saving changes that you don't want saved, but I find that the danger of losing work is greater.