remove workbook links?

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

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?

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

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?

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