Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

What is Wrong With Dynamic Data Exchange (DDE) for Real-Time Data?

April 26, 2017Data dde Dynamic exchange real-time wrong

0

Posted

What is Wrong With Dynamic Data Exchange (DDE) for Real-Time Data?

1 Answer

0

Posted

DDE has often been used to try to implement real-time data in Excel, but it has several limitations. Here are some of them: • DDE has a different function format from standard Excel functions. • DDE can’t use cell references in a function; everything must be hard coded. • DDE gets confused when things are happening in Excel (for example, a calculation is taking place, a dialog box needs to be handled, and so on). • DDE wasn’t designed for getting asynchronous data in Excel in a robust and high-performance way.