Breaking Links

T

tojo107

Each month I have to break the links in about 40 workbooks, each with 10-15
worksheets in each.

Currently, I open each workbook, group all the tabs and then Copy/Paste
special values to break links.

Is there an easier way to this - sort of like a batch???

Thanks,
Tom
 
S

sebastienm

Hi,

To change the links in a book or break the links in a book:
- manually: menu Edit > Links, there change the source book or break the
links.
- programmatically:

To break all links for cells referencing to sourcebook.xls on C:\
ActiveWorkbook.BreakLink Name:= "C:\sorcebook.xls", Type:= xlExcelLinks

To change the links , use ActiveWorkbook.ChangeLink....

Now loop throught the books to process
-open one
- change/break link
-close it
- next one
 
D

Dave Peterson

In newer versions of excel (xl2002+, IIRC), you can choose:

Edit|Links|Break link.
 
Top