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