![]() If you've removed all external references from formulas but Excel still says there are links to external workbooks, then check other possible locations discussed below. With Find and Replace you can only identify external links in cells. This will select both the results in the Find and Replace dialog box and the cells in the workbook. To select all cells with external references, place the cursor anywhere within the results and press Ctrl + A.To group the found links the way you want, click the corresponding column header, for example, Sheet or Formula. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |