![]() So, this can become a quick check to verify if your excel sheet contains external references or not. Please note that this option will be disabled by default and will only become active if your sheet contains some external references. On the excel ribbon there a ‘Data’ tab, inside this tab, there is an option called “Edit Links”.īasically, the edit link option displays all the other files to which your spreadsheet is linked to. ![]() The resultant will be a set of external references that are used in the sheet.Next, in the ‘Look in’ dropdown select Formulas and hit the “Find All” button.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |