Cut links between worksheets in same workbook
 

I have set up a template with hundreds of links to other worksheets in the
same workbook. I want to cut the links, so that only the data (values) shows,
after I have made a copy of the template.

My toolbar Edit does NOT display the LINKS option, even though there are
dozens of links in the template. Why is this? How can I cut the links? I
have done it previously, but only where there was a link between workbooks,
not worksheets.

Thanks
Lesley

Dear Sir,

Try this:

Select the cell(s) where you want to broke the links and do this:

Edit copy
Edit Paste Special -- select "Values" from the options available

Hope this helps!

Regards

Juan Carlos


--
cscorp
------------------------------------------------------------------------
cscorp's Profile: http://www.excelforum.com/member.php...o&userid=24015
View this thread: http://www.excelforum.com/showthread...hreadid=377003