Recovereing Previous Versions

[Fyrwych]

Is there anyway to tell Excel to store a number of previous versions of a worksheet? For example, can you set it to save (and make recoverable) the last 5 versions of a worksheet? It seems to only save a file now if the system crashed.

 

[Bob Ully]

Number your excel files, Sprd-01,Sprd-02, etc. You can record a macro to save your sheet right after you open it with a new number.