Save Data Every 1 minute

It's not difficult to do, but the one thing to mention about this is that if saving your workbook takes more than an instant, it can cause unwanted pauses in the operation of your workbook, so take that into account and test on sample files first. That said, this working well will depend on a number of factors.

Here is the tutorial that shows you how to run a macro at intervals:

Run Macro at Set Intervals

To do the saving you can use ThisWorkbook.Save

Workbook.Save MSDN Article

There is a tutorial on this site. I see it advertised to the left of my posting screen. It's named "Run a Macro at Set Intervals in Excel". Set that progrm up to run every minute and let it execute a procedure that saves your workbook.