Breaking Links

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

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

--
Regards,
Sébastien


"tojo107" wrote:

> 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

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

Edit|Links|Break link.



tojo107 wrote:
>
> 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

--

Dave Peterson