MrExcel Publishing
Your One Stop for Excel Tips & Solutions

remove workbook links?


Posted by Joe Was on May 15, 2001 8:28 AM

Renaming the source workbook to the calling book, just copies the existing data back onto itself but offset. Anybody know how to remove workbook links?


Posted by Barrie Davidson on May 15, 2001 8:34 AM

Do you want to keep the values from your linked workbook?

Posted by Joe Was on May 15, 2001 9:37 AM

Barrie, no values from linked workbook and no link

I want to remove the link and keep the calling workbook the way it is without any link.
No values are needed from the linked workbook.

The application trackes data for one job, a different application keeps a running list of all jobs. The running list application contains search macros, the job application has none. The link was to automatically add job information to the running list application when a button was pressed. This function failed, but has left the applications linked. I want to unlink then so I can more accurately debud the code?

Posted by Barrie Davidson on May 15, 2001 9:44 AM

Re: Barrie, no values from linked workbook and no link

You could do a "search & replace". For example, if the linked file name is Book1.xls you could search for *book1.xls* and replace with "". This will clear out anything with book1.xls in its formula.

Barrie

Posted by Joe Was on May 15, 2001 10:29 AM

Re: Barrie, no formulas have a link


Barrie, No formulas contain a link, a sheet in one workbook is linked to another workbook with the links utility. When I set the links menu to the current workbook as the source it copies all the data back on the sheet only moved right three columns. And that is the only way I know of to cancel a link?
Any ideas?

Posted by Sean on May 15, 2001 12:16 PM

Re: Barrie, no formulas have a link


I've had this when I have named ranges in one book
try Insert/Names/Define This brings up the Define name box, you may find a name has been created that references the linked file, scroll through each name in the box checking in the Refers to section and see if the Linked file appears if it does (and you are sure you no longer need the link) highlight this link and delete it.

If this was the last reference to the linked file.

Edit/Links will now be greyed out.

Hope this helps.

Sean
s-o-s@lineone.net