Kbase 21409: Error: DDE failed. (3153)
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  10/16/2008 |
|
Status: Verified
FACT(s) (Environment):
Microsoft Excel 2000 Spanish Edition
SYMPTOM(s):
Error: DDE <type> failed. (3153)
CAUSE:
This error stands for "data not accepted". When you are using DDE SEND, you also need to define the ITEM like so: DDE SEND sheet SOURCE "Name" "R1C1".
In an English version, this ITEM could be called "R1C1" (row 1 column 1).
FIX:
If you need to find out what sheet row and column in other languages, follow these steps:
1) Open a new sheet in Excel.
2) Change to R1C1 Reference Style (Tools > Options > General > Setting
and select R1C1 reference style)
3) Type something on Sheet 1, R1C1 and copy the cell content.
4) Turn to Sheet 2 and select any row and column.
5) Right click to do Paste Special.
6) Select Paste Link button.
Immediately, you should see "=Sheet1!R1C1" in the formula cell above.
To do this in other languages, you should be able to find out
what is sheet, row and column in that language.