I’m Implementing DDE Server for Excel Clients to provide them with stock market real time data that updated from lightstreamer server

I used Ndde.Dll and created a class that inherits from NddeServer where I override the following methods and events
Code:
OnBeforeConnect()
OnAfterConnect()
OnDisconnect()
OnStartAdvise()
OnStopAdvise()
OnExecute()
OnPoke()
OnRequest()
OnAdvise()
Advise()
- When application starts up I register the server and then when there is any updates
I call the serverObj.Advice(Topic, Item). e.g serverObj.Advice(“Topic”, “item~Id”).

- Client select some data from data grid view rows that updates automatically from lightstreamer subscriptions he needs and copy them then opens excel sheet and paste the selected data items

- The formula of each cell looks like ‘ServerName|TopicName!’ItemName~Id’.

Issue is when data items updated in system they didn’t in Excel sheet
- Could you help me, how can I fix this???
- Is there alternative methods for using DDE or missed steps to do??