Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Want Excel to break links between worksheets in same file | Excel Worksheet Functions | |||
Emailing a workbook with links | Excel Worksheet Functions | |||
find links to another workbook | Excel Discussion (Misc queries) | |||
#VALUE ! errorr for links to other workbook | Excel Worksheet Functions | |||
Removing links to other worksheets from within a workbook | Excel Discussion (Misc queries) |