Where is links in excel 2010

Seems like it should be easy, but as you are probably finding out, it sometimes isn't as easy as clicking the "break links" button unfortunately. In this post, I am going to walk you through all the hiding places that external links may be lurking.

External links in cells are typically the easiest to find and remove. You should always start by using the Edit Links Dialog. You can get to this dialog box by navigating as follows:. When you see the Edit Links dialog appears, you will see a listing of all the external Excel files that are getting data pulled from them. You will get a prompt shown below asking if you are sure you want to break the links as this action is irreversible.

Click Break Links and all your links "should" be broken. In a perfect world, the Edit Links button will be grayed out and all your external links will be removed. However, this is far from a perfect world! Sometimes certain links cannot be broken via the Edit Links dialog. In other cases, you will still get prompts stating that there are external links in your workbook. If you are still thinking there are external links in your workbook, continue reading on to learn where else those pesky links may be hiding.

External Links can reside inside any textbox of a Chart object. This includes the:. It then displays all results in its window, so all you have to do is click a result to view the link.

Click the "Insert" tab at the top of the Excel window and click "Hyperlink" in the Links group. The Insert Hyperlink window pops up. Type a name for your new link in the Text To Display box and an address in the Address box.

Click "OK" to insert the link. The Find and Replace window pops up. You can also update links, change links source, and check links' status. You are able to break links in the Edit Links dialog box. If you click the Edit Links button, you will view the Edit Links dialog box as figure 2 shows. The Break Links feature stays in the Edit Links dialog box. In the Edit Links dialog box, you can view, change, update, and break links as you required.

Brings the familiar classic menus and toolbars back to Microsoft Office , , , , and Supports all languages, and all new commands of , , , , and have been added into the classic interface.