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