how do I break links to external workbooks en masse?
Hi Dave,
click on Edit menu, and find a comand link or bond (as my excel is in
Braziliam Portuguese, I'm not sure the name), and break all links.
once a link is broken excel will maintain the values
hth
--
regards from Brazil
Thanks in advance for your feedback.
Marcelo
"Dave F" escreveu:
Hi,
I have a workbook which has links to about a dozen external workbooks. I'd
like to sever all external links and just replace those cells' links with
values. I know there is VBA code to do this quite easily, but I don't
remember what it is....
Thanks.
Dave
--
Brevity is the soul of wit.
|