From Friday, April 19th (11:00 PM CDT) through Saturday, April 20th (2:00 PM CDT), 2024, ni.com will undergo system upgrades that may result in temporary service interruption.

We appreciate your patience as we improve our online experience.

LabVIEW

cancel
Showing results for 
Search instead for 
Did you mean: 

update links in excel

When I open my spreadsheet directly from excel it opens without having to "update links". But when I try to launch excel using Active X (invoke Node) it does not and I have to manually click on "update links" and "select source".
I would like not only to open the spreadsheet but automatically update some cells using LV GUI and do not want any manual interaction. On the otherhand, if I open the spreadsheet directly and close it keeping the excel application open, and then try to open the particular work book, it does not ask me to update links again and I am able to update the cells automatically. Is there anyway I can launch excel and open the work book without having to manulayy click on "update links" and "select source". Any help is greatly appreciated.

Sheela
0 Kudos
Message 1 of 2
(2,268 Views)
Updating links and selecting sources is all on the Excel side of things, so I can't offer much help on that. But I Googled "excel update links" and found a couple of sites that might help:

http://www.mrexcel.com/archive/Links/22078.html

http://www.microsoft.com/technet/prodtechnol/office/office2000/tips/exlink1.mspx

I hope these help you out.
0 Kudos
Message 2 of 2
(2,253 Views)