It was my understanding it works (and of course help supports that).
However, as a fall back, the time tested

workbook level property
SetLinkOnData

should work.

--
Regards,
Tom Ogilvy

"li" wrote in message
...
Tom, thanks for your reply. I tried, it seems that the change event was
not
be triggered when the linked data changes.
IS there anything else that i can do?
Thanks
--
cc


"Tom Ogilvy" wrote:

From help on the change event:

Occurs when cells on the worksheet are changed by the user or by an
external
link.

-------------------------------------------------------------

If you are using xl97, this didn't work, but it was fixed in xl2000 and
later. Where do you get your information?

--
Regards,
Tom Ogilvy


"Rody" wrote in message
...
Sorry Tom,

The change event will not be triggered when the linked data changes.

Rody


"Tom Ogilvy" schreef in bericht
...
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