Reply

XLS link to the part

[ Edited ]

 

Hello guys,

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.

Roman

 

Posted by: Roman Racak
Post date: 8/18/2010 12:23:23 AM

3 REPLIES

RE: XLS link to the part

[ Edited ]

Yep, thats a real pain. You have to re-establish a link to that file before you can properly delete it.

Try this:

 

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.

Good luck.

 

Posted by: Jon Zaerr
Post date: 8/27/2010 11:11:18 AM

RE: XLS link to the part

[ Edited ]

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

Re: RE: XLS link to the part

rather than break the link, re-past as a value.