I have a spreadsheet whose data is updated from an external source every second(the time interval of update is user definable). I want to store the data every second in an excel workbook so that I can analyse the data later.

how do i do this?