You would have to save the value somewhere else each time it changed. See
the Change Event

http://www.cpearson.com/excel/events.htm

--
Regards,
Tom Ogilvy


"DDE data history" <DDE data wrote in
message ...
I created a DDE link between an excel 2003 file and another applicaition
program for data acquisition.
However, the cell that was linked with the application program only has
the
latest data. How can i get the data history?
Thanks! i am a beginner in excel. please give me detail instructions