Ask Your Question
0

How do I clear existing links in cells in a multi-sheet spreadsheet that link to other spreadsheet files?

asked 2017-07-21 18:21:59 +0100

jer gravatar image

updated 2017-12-10 17:04:19 +0100

erAck gravatar image

They are legacy from Excel converted sheets and I don't know where or who they are. They are non-working but probably have a value in the cell I need to keep using. And they could be in any of the 9-10 sheets in the file. I just want to quit getting the alert every time I open these spreadsheets that there are cells linked to some other spreadsheet. I always respond Not To Update but I want them unlinked. Ver 5.4.3.2 on Win 10 system.

edit retag flag offensive close merge delete

1 Answer

Sort by » oldest newest most voted
0

answered 2017-07-22 01:26:46 +0100

m.a.riosv gravatar image

It should be available on Menu/Edit/Links - Break link selecting all links.

edit flag offensive delete link more
Login/Signup to Answer

Question Tools

1 follower

Stats

Asked: 2017-07-21 18:21:59 +0100

Seen: 31 times

Last updated: Jul 22 '17