| T O P I C R E V I E W |
| freddie_mclair |
Posted - 11/30/2016 : 02:54:20 AM
Hi!
Is there some way that every time I open Origin, it reads some cells from an Excel file, and automatically updates cells on an Origin worksheet? Check the scheme below.
Of course I can do a copy-paste every time, but I would like to have it automatically.
Thanks in advance!
Freddie
Origin Ver. and Service Release: OriginPro 2016 (64bit) b9.3.1.273, Sr1
Operating System: Windows 7 |
| 3 L A T E S T R E P L I E S (Newest First) |
| snowli |
Posted - 11/30/2016 : 08:42:59 AM
Hi Freddie,
We have fixed the issue in latest released Origin 2017 so you will not see the message every time you start Origin 2017.
See release notes https://originlab.jira.com/wiki/display/main/Origin+2017+Importing+and+Exporting
ORG-12950 Avoid DDE message if linked Excel is open inside opj
Thanks, Snow |
| freddie_mclair |
Posted - 11/30/2016 : 06:01:47 AM
Hi, this worked! Thanks Amanda!
I have to keep the Excel workbook always inside Origin, right?
Another thing, how do I avoid to press "Yes" on the "Start DDE Link" query every time Origin starts? I mean, I would like it to select "Yes" automatically, and avoid several clicks.
Thanks again! |
| AmandaLu |
Posted - 11/30/2016 : 04:45:22 AM
Hi,
You can try the following:
1. Open the excel file inside Origin, by File: Open Excel.
2. Copy the desired columns and go to the target worksheet, right click on a cell and select Paste link.
3. Save the whole OPJ.
4. Then you can update excel file. When you open the OPJ next time, the data in worksheet will be updated automatically.
To keep the link between the excel file and OPJ, I suggest to save the excel file in the same folder with the OPJ, and check the “Relateive to current project (OPJ) path” in the Workbook Properties dialog (right click on the excel workbook window title and select Properties).
Thanks,
Amanda
OriginLab Technical Service
|
|
|
