| Author |
 Topic  |
|
|
tybrad11
3 Posts |
 Posted - 07/26/2011 : 4:05:03 PM
|
Origin Ver. and Service Release (Select Help-->About Origin): 8.5.1
Operating System: Windows 7
Excel Version: Office 2007
When I copy and link data from an Excel worksheet into an Origin Workbook (when both are part of a project), it seems to work fine while the project is open. Then, when I close the project I get a message "There are active DDE links which exist with other application(s). Are you sure you want to exit?"
After I exit the project, and then try to open it again, I get an error message, "There was a problem sending the command to the program," and it doesn't open. If I click to open it again, it opens, but then asks "Start external link with Excel for the following DDE object?" If I click yes, it pops up again. I have to do this for each individual DDE link I made (which are hundreds). How can I get the links to work automatically?
Things I've tried:
-Made sure Excel isn't "Ignoring other applications that use DDE"
-Made sure Excel doesn't "ask to update automatic links"
-Tried saving the excel file as both internal to the project, and external. Neither worked.
-Tried moving both the project and the excel file to a different local disk.
-Tried making links with a simpler project: I made a single link between an excel worksheet and a workbook. I received the same errors. |
|
|
minimax
348 Posts |
Posted - 07/27/2011 : 12:58:00 AM
|
Hi Tyler,
Maybe following info can help:
Two system variables (available since 8.1 sr3) which can be used to preclude the two DDE prompts:
@DDES: determines the behavior of the "Start DDE Link" dialog:
= 0 (default) show the dialog if necessary
= 1 do not show the dialog, assume "Yes" answer to the dialog.
= 2 do not show the dialog, assume "No" answer to the dialog.
= 3 do not show the dialog, assume "No and Remove it" answer to the dialog.
@DDEL: determines the behavior of the "Remote data is not accessible. Start Application..." prompt:
= 0 (default) show the prompt
= 1 do not show the prompt and assume "Yes" answer.
= 2 do not show the prompt and assume "No" answer.
|
 |
|
|
tybrad11
3 Posts |
Posted - 07/27/2011 : 10:37:37 AM
|
Thanks minimax, that now saves me time from having to click yes a couple hundred times just to open the project. However I will be sharing this project with a group of people, and don't want this error reproduced; I'm hoping to fix the underlying problem more so than cover it up with a band-aid.
Nonetheless, I much appreciate the useful tip. |
|
|
|
tybrad11
3 Posts |
Posted - 08/11/2011 : 11:53:17 AM
|
| I even tried using excel links on another computer (same Origin version, different OS) and I get the same errors. Has anyone with Origin version 8.5.1 been able to get excel links to work, without having the same problems I get? Do excel links work in other versions? |
|
|
|
snowli
USA
1386 Posts |
Posted - 08/11/2011 : 2:50:33 PM
|
Hello,
We tracker this problem in ORG-3513 and will try to fix it so origin cell link will be done instead of DDE link.
Thanks, Snow Li |
|
|
| |
Topic |
|
|
|
Excel Links Don't Work