![]() Click OK, twice, to close the dialog boxes. Remove the check mark from Internet and network paths with hyperlinks. Click the Proofing category, and click the AutoCorrect Options button. To remove Phantom Links from a workbook, first check to make sure that there are not any non-phantom links in the file. To turn the hyperlink option off in Excel 2007: Click the Office Button, then click Excel Options. ![]() You should see a new sheet with all the issues listed out. If you have ever opened an Excel file and been prompted to update links to another file, yet you are certain that there are no links to any other files, your file may contain phantom links. In the Compatibility Checker dialog box click the Copy to New Sheet button In the Info section, select the Check for Issues drop-down Using The Compatibility Checker to Find Data Validation Errors: You can manually search through each of your Data Validation rules within your workbook however, that may be a daunting task if you have a lot of tabs to search through. An easier way is to use the Compatibility Checker to search for you. This can occur as the Source input for a List rule. ![]() Removing External Links From Data Validation RulesĮxternal Links can reside in Data Validation rules.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |