DDE link and excel

Hello everyone

At the moment I am trading future contracts and I am using a DDE link and excel to capture live data. Excel has a “refresh data at intervals” function but I can’t seem to be able to populate the excel sheet by keeping the old data from the previous intervals.

Does anybody know how to populate a spreadsheet in that way?

I would greatly appreciate if somebody could point me in the right direction

Thanks