How Excel work with DDE?

[JoySun]

The Measurement data could be sent to EXCEL by DDE. 
We can see the data show out in DDE server.
The data also show out in Cell(21,4),
    refers the example download from:
    http://www.aggsoft.com/asdl-excel-read-via-dde.htm

Why the data will not show out in Cell(1,1), Cell(2,1),..., etc.,
   When data send out one by one?

Why the VB does not execute "Private Sub Worksheet_Calculate()"
   or "Private Sub Worksheet_Change(ByVal Target As Range)"
   when DDE transfer data to correct location.

When manual typing data instead DDE doing to Cell(21,4),
   the excel does execute VB and send data to Cell(1,1), Cell(2,1),...,etc..

The system OS is WinXP Pro. SP3, Excel is 2003 SP3.

[Arthur Grasin]

Did you allow macros in Excel? When you open the example file, the Excel should ask you about it.