Removing Links

Tkaraly123

I accidently added linkage from one sheet to another. How do I remove those linkages? There  are a total of 10 rows and 12 columns that were linked.

 

Thanks!

Mike Wilday

You can select all the linked cells then right-click and choose - Remove Link. Then you will need to delete the linked cell data

 

 

Tkaraly123

Thank you very much! I found out I could only remove the link from the source page. You saved me so much time!

Mike Wilday

Glad I could be of assistance!  

Dolley

Thanks @Mike Wilday . I am having the same trouble; however, I don't have the option to remove link.

This is what I am seeing after I right-click.

Mike Wilday

@Dolley It looks like you are selecting content that is not linked from other sheets. Try selecting the content one column at a time.

Dolley

@Mike Wilday I have been deleting cells one by one and I'm looking for a better way to do it. Unfortunately, the sheet where I intended to link this work has been deleted because I couldn't figure out how to make it work. As a result, the source sheet still shows arrows pointing out even when I select the group in a column. However, the option to remove them is not available to me.

Mike Wilday

I would reach out to support. I'm not sure how to resolve that. But that makes a lot of sense.

Dolley

As always, @Mike Wilday , thanks for your help and prompt responses.

Mike Wilday

You're welcome!!! :D