That’s all there is to it you’ve now altered your options so that you may format cells, allowing you to break them. Ensure “Format cells” are selected, also make sure that the first two sheet lock and unlock settings are also selected.
#Permantly disable links in excel how to
Step by step process – The “break link” button is not working – how to fix Follow through for the steps on how to resolve the “break link” button not working. To resolve this, remove the protection from the workbook and sheet. This happens when you protect either the sheet or the workbook. The loss of the “break link” option button indicates that it is no longer active. You may assume your link that’s not working, however, if the link isn’t working it’s still able to break or it won’t register as a link, so clearly the link is working, there is only one logical explanation as to why the break link button is not working. So you have followed all the steps to break the link - you have reached up to the part where you need to click on the “Break Link” button, only to find that the button is not available for you to click on it. The break link button is not working – and how to fix it: Excel
#Permantly disable links in excel mac
Let’s go over each of the scenarios and how to solve them.Ĭompatible with Windows, Mac OS, and Android. The break link button may occasionally operate but not break the link. However, in some circumstances, the break link option dims and does not function. If you are not able to break the link because the edit button is greyed out then a reference link to an external file is not present you need to have some form of connection to an external file to ensure the link works. These are the necessary steps to ensure the link is broken.