i have been trying to work with SE part (in VB) which has link to XLS worksheet (see attachment). All I need is set up 'update' option of this link to 'manual' state. Or, and this could be even better, break this link completely. There were some formulas containing XLS string inside of variable table - i already cleaned it, but it was not enough. When i open some ASM with this part (with this link to XLS), it take incredibly long time. This part is saved in shared folder (we don't use insight connect). Thank you for your help.
Posted by: Roman Racak
Post date: 8/18/2010 12:23:23 AM
Yep, thats a real pain. You have to re-establish a link to that file before you can properly delete it.
make sure the specified file exists. IF not, you could use Rev Mgr to point to a new XLS file.
create a dummy variable in the variable table of your model
Open the spreadsheet, highlight a cell, and CTRL-C
move back to your model, in the variable table in Formula, right-click paste link
right click (any field of any variable) - Edit Links (opens the Links dialog)
hightlight the Excel source file - click Break Link - Click Yes
Delete the dummy variable.
I might have a few details wrong, but I know this will work, because I've done it on hundreds of files.
Posted by: Jon Zaerr
Post date: 8/27/2010 11:11:18 AM
I'm trying to do this as well but I can't find anything that says "Break Link".
Posted by: Terry Tyson
Post date: 10/27/2010 8:40:34 AM