![]() ![]() The Break Link function replaces the external links in any formulas with constant values. This step will succeed in breaking links unless there are “phantom links” with the workbook. Once all the sheet are unprotected you can go on the next step. Under PROTECT WORKBOOK at the top you will see a list of any protected sheets. If you are using Excel® 2010 or later you can go to FILE – INFO. You can use our audit tools to find all cells with external links. Excel® will give you a warning that the external link cannot be broken due to the sheet being protected.Įxcel® won’t be helpful enough to tell you which sheet contains the external link so you may need to go searching for it. Advertisementsī) If a cell within a protected sheet is linked to an external file then you won’t be able to break links. ![]() You will need to unprotect this sheet or go to another sheet before you try and break links. Unprotect Sheets in your Problem FileĪ) When the active sheet is protected and you try to edit links the BREAK LINK button will be grayed out. Lets go through each of those steps in more detail to make sure you can break links. Some of these problems can be fixed with our add-in: fix and speed up Excel® files tools ADD-IN. Save the file as file type ‘xls’ then back to ‘xlsx’ (or whatever the original file type was).Navigate to the folder ‘FILENAME.zip>xl’ file and delete the folder named ‘externalLinks’. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |