Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Facebook Twitter Instagram
Tech News Today
  • Hardware
    • Motherboards
    • CPUs
    • Graphic Cards
    • RAM
    • SSDs
    • Computer Cases
    • Monitors
    • Peripherals
    • Power Supply Unit
    • PC Builds
    • Computer Tips
  • Software
  • Operating System
    • Windows
    • Mac
    • Linux
  • Gaming
  • Mobile
  • Console
  • More
    • Internet
    • Networking
    • Security
    • Buyer’s Guide
    • Gadgets
    • Laptops
    • Reviews
    • How To
    • News
Tech News Today
Home»Software»Excel»How to Find and Edit External Links in Excel

How to Find and Edit External Links in Excel

Asmi DhakalBy Asmi DhakalJanuary 13, 2023
how to find links in excel

Excel allows you to refer to external documents from your current spreadsheet. As Excel does not apply special formatting on data sourced from a different file, you will have issues locating them. When you cannot locate your links, you will fail to make the necessary changes to the reference.

You can find links in Excel depending on where they’ve been stored. For starters, you can use Sort and Filter tool to find links from an Excel column. If you’ve used an external reference to use features such as Conditional Formatting and Data Validation, you can make changes to your entered data to edit links.

Using Sort and Filter

This tool is amazing if you haven’t used a different display text for your link. You can filter all existing data except for workbooks that usually have the .xlsx extension.

  1. Select your data in the workbook.
  2. Head to Insert > Table.
    Insert Table Excel
  3. Click on the drop-down menu on your table header.
  4. Deselect the box for Select All.
    Sort and Filter Tool Excel
  5. Type .xlsx in the search bar, then click OK.
    Sort Excel References in Column

The Sort and Filter tool will sort all workbook links with the .xlsx extension from the rest of your data. You can right-click on the cell you wish to edit and choose Edit Hyperlink. 

Use Edit Links Tool

You can use Edit Links to view all external links you’ve added to your workbook. This also includes hidden and broken links. All links you’ve embedded to retrieve data from external sheets charts, name manager, and even a cell is displayed on the Edit Links window.

  1. Open your worksheet.
  2. Head to the Data tab.
  3. Select Edit links from the Connections section.
    Edit Links Option
  4. You can view and make changes to each of your links in this view:
  • Update Values: If you have changed the location of your embedded document, Excel will open File Explorer where you’ll have to navigate to the new location of your document. Else, it will update the status of the selected source.
  • Change Source: If you wish to change the document, select this button. You can select your new document from File Explorer.
  • Open Source: You can head to the source document by clicking on this button.
  • Break Link: If you no longer wish to update the values according to the source document, you can select the Break Link option. Your reference will change to static values and any changes you make in the source document will not affect your destination document.
  • Check Status: You can check the status of your source file after you click this option.
    Edit Links Window
  1. After making the changes, select Close.

Why is Edit Links Option Grayed Out?

Edit links grayed out Excel

The most common for the Edit Links option to be grayed out is that you do not have a cell or object referring to an external link.

The Edit Links window is only available to check and make changes in external links. This option will not work if you’ve embedded your link as a hyperlink. If you’re looking to edit hyperlinks, you can right-click your cell with the hyperlink and select Edit Hyperlink.

how-to
Asmi Dhakal
  • Twitter
  • LinkedIn

Asmi Dhakal is a Tech Writer specializing in Microsoft Office-based programs at TechNewsToday. She aims to use her experience to help others learn their way around its programs. Asmi’s interest in Office products grew when she first entered the marketing industry. While she initially struggled to understand their application, she eventually understood her way around them. In her articles, she exhibits a strong understanding of related issues and attempts to push only relevant fixes. Over time, she has grown a particular fondness for MS Excel and spends her free time learning Visual Basic Analysis (VBA). She’s always on the lookout for productivity tools that can get the job done quicker in Excel. Her approach to related problems is very humane, helping new users not only fix the issue but learn more about its nature. Asmi also heavily indulges in personal writing. She is a disciplined journal writer and has maintained a regular journal for 8 years! When her schedule allows, she works to rehabilitate street animals. You can contact her at asmi@technewstoday.com

Related Posts

check mark in excel

How to Put Check Mark in Excel

January 20, 2023
best excel shortcuts

Best 52 Excel Shortcuts Only Experts Know

January 19, 2023
How to Find and edit Hyperlinks on Excel

How to Find and Edit Hyperlinks on Excel

January 23, 2023
how to find unique values in excel

How to Find Unique Values in Excel

January 15, 2023
reference isn't valid excel

Reference Isn’t Valid Excel Error – 6 Ways to Fix it

January 6, 2023
how to set print area in excel

How to Set Print Area in Excel

January 5, 2023
Add A Comment

Leave A Reply Cancel Reply

Latest Posts
usb a vs usb c

USB A Vs USB C – What’s the Difference?

January 31, 2023
how long does a cmos battery last

How Long Does a CMOS Battery Last

January 25, 2023
thunderbolt vs usb c

Thunderbolt Vs USB C: What’s the Difference

January 25, 2023
You may also like
scroll wheel not working

Scroll Wheel Not Working? Try These 6 Fixes

February 5, 2023
how to connect canon printer to laptop

How to Connect Canon Printer to Laptop

February 5, 2023
how to change mouse sensitivity

How to Change Mouse Sensitivity (5 Effective Ways)

February 5, 2023
Recommended
Cookie Clicker Garden Guide

Cookie Clicker Garden Guide to Unlocking Every Seed

September 26, 2021
monitor no signal

Computer Turns On But Monitor Says No Signal (9 Ways To Fix)

November 10, 2022
Facebook Twitter Pinterest
  • Home
  • About Us
  • Our Team
  • Editorial Guidelines
  • Privacy Policy
  • Affiliate Disclosure
© 2023 TechNewsToday.

Type above and press Enter to search. Press Esc to cancel.