Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

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

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.

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

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.