Cut links between worksheets in same workbook

H

Houndstooth

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
 
C

cscorp

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
 
Top