| View previous topic :: View next topic |
| Author |
Message |
markhennig
Newbie
Joined: 08 Mar 2004
Posts: 2
Location: Germany
|
 Posted: Thu Mar 11, 2004 12:58 am Post subject: DDE links are unreliable! |
 |
|
There are 6 DDE links (automatic) to an external realtime datasource in a Calc document.
Unfortunately, I can never rely on any result shown in these cells.
Sometimes a DDE cell lags the realtime data only by half a second (that's acceptable) but other cells lag way too many seconds (even minutes) or important data isn't shown at all.
Is there something one can do about it?
Are dde links working better in Excel?
Thanks,
Mark |
|
| Back to top |
|
 |
JohnV
Administrator
Joined: 07 Mar 2003
Posts: 8995
Location: Lexinton, Kentucky, USA
|
| Posted: Thu Mar 11, 2004 5:24 am Post subject: |
|
|
| Quote: | Is there something one can do about it?
|
Have you tried Tools > Update > Links? If this works as expected then you can record a macro to run it (when I did I had to edit it to remove the REM statement from the last "dispatch" line). Now you could create a button in the margin of your doc to run the macro when needed or assign it to a key combo, etc. |
|
| Back to top |
|
|
dfrench
Moderator
Joined: 03 Mar 2003
Posts: 1605
Location: Wellington, New Zealand
|
| Posted: Thu Mar 11, 2004 11:37 am Post subject: |
|
|
I assume that this relates to your issue http://www.oooforum.org/forum/viewtopic.php?p=24467 ... You can put the update code into the loop that I suggested there.
Have you verified that the supplier of the DDE data is actually relinquishing control to the os fast enough? |
|
| Back to top |
|
|
|
