Remove Cell Linkage

Brenda K

I had previously created a sheet that inputted data via cell linking.  However, the use of that sheet is no longer needed so I deleted it.   The problem is that the sheet that was 'pushing' the data still shows the outgoing cell link.  How can I remove the cell linking?   

Taylor F

If the source sheet has been completely deleted, you will have to delete each Cell Link on the destination sheet by clicking on the cell and click delete in the hovering window. If your sheet can be retrieved from the Deleted Items folder under the Home tab, you can select all of the linked cells and click delete on the keyboard.

Ian

What is the proper way to delete linking of a range of cells?  I want to make sure that when I remove the link on either the source or destination that it removes the linking information on both sheets.  It seems like each time I remove it on one sheet I then have to manually remove from each cell separately on the other sheet.

 

Thanks

Ian

Taylor F

Hello Ian,

 

The best way to remove links is to open the destination sheet, select all of the cell that contain Cell Linking, right-click any of the selected cells and choose Remove Link. This will break the connection between the two sheets and you won't have to return to the source sheet to delete the Cell Linking. 

 

NOTE - when you remove the links from the destination sheet, the values will remain. If you haven't yet clicked off of your selection, you can clear all of the data by pressing the delete key on your keyboard.

Battleboards

Please Help,For the life of me I cannot remove a hyper link. I added a simple telephone number and it show as a link (blue with underline) 

I want to remove this as it not a link, just a number. 

I tried all methods that would normally remove this. i.e

right click on cell (no remove) 

Ctrl C - Ctrl V (even special paste still keeps it. 

 

Any help would be appreciated

 

J. Craig Williams

See my comment here:

https://community.smartsheet.com/comment/60261

There is now a way to delete the <unknown sheet> references.

Craig