You would need to write your own macro using the before save event or on open
event. The macro would move previous saved versions do an archieve directory.

"GRAPH WITH A MACRO" wrote:

I mean, as we do the work in excel it should automatically save in another
workbook as backup copy... it should be updated as we save the workbook.