Fix broken links to data (2024)

Excel for Microsoft 365 for Mac Excel 2021 for Mac Excel 2019 for Mac More...Less

If your workbook contains a link to data in a workbook or other file that was moved to another location, you can fix the link by updating the path of that source file. If you can't find or don't have access to the document that you originally linked to, you can prevent Excel from trying to update the link by turning off automatic updates or removing the link.

Important: linked object are not the same as hyperlinks. The following procedure will not fix broken hyperlinks. To learn more about hyperlinks, see Create or edit a hyperlink.

Fix a broken link

Caution:This action can't be undone. You might want to save a backup copy of the workbook before you begin this procedure.

  1. Open the workbook that contains the broken link.

  2. On the Data tab, click Edit Links.

    The Edit Links command is unavailable if your workbook doesn't contain links.

  3. In the Source file box, select the broken link that you want to fix.

    Note:To fix multiple links, hold down Fix broken links to data (1), and then click each link.

  4. Click Change Source.

  5. Browse to the location of the file containing the linked data.

  6. Select the new source file, and then click Change Source.

  7. Click Close.

Remove a broken link

When you break a link, all formulas that refer to the source file are converted to their current value. For example, if the formula =SUM([Budget.xls]Annual!C10:C25) results in 45, the formula would be converted to 45 after the link is broken.

  1. Open the workbook that contains the broken link.

  2. On the Data tab, click Edit Links.

    The Edit Links command is unavailable if your workbook doesn't contain links.

  3. In the Source file box, select the broken link that you want to delete.

    Note:To remove multiple links, hold down Fix broken links to data (2), and then click each link.

  4. Click Break Link.

  5. Click Close.

See also

Import data from a CSV, HTML, or text file

Need more help?

Want more options?

Discover Community

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Fix broken links to data (2024)

FAQs

Fix broken links to data? ›

Reasons for Broken Links

There are various reasons that broken links can occur, for example: The website owner entered the incorrect URL (misspelled, mistyped, etc.). The URL structure of your site recently changed (permalinks) without a redirect and it's causing a 404 error.

How do you fix a broken link problem? ›

Tips for fixing broken links
  1. Remove punctuation at the end of the link. ...
  2. Fix syntax problems. ...
  3. Copy and paste the link instead of clicking. ...
  4. Delete everything after the domain name. ...
  5. Solving more difficult problems.

How to repair layers in a data source? ›

Repair a broken data source link for a layer or table
  1. In the Contents pane of a map, right-click the dataset, and click Properties.
  2. On the Source tab, click Set Data Source.
  3. On the dialog box that appears, browse to the data source, select it, and click OK.

Why are all my links broken? ›

Reasons for Broken Links

There are various reasons that broken links can occur, for example: The website owner entered the incorrect URL (misspelled, mistyped, etc.). The URL structure of your site recently changed (permalinks) without a redirect and it's causing a 404 error.

How can you restore a broken link to an external resource? ›

If you know the new location of the linked external file, click Change Source, go to the new location of the external file, and then click Open. In the Links list, click the correct path to the linked worksheet, and then click Update now.

How to get rid of broken links? ›

Get Rid of Broken Links on Your Site
  1. An SEO audit tool like Ahrefs – this is our recommended method if you have access to such a tool. ...
  2. The Crawl Error reports in Google Search Console.
  3. Free desktop SEO software like Screaming Frog.
  4. A free web-based tool like BrokenLinkCheck.com.
Mar 4, 2019

How do I fix a URL link? ›

How to Fix URL Problems: 9+ Easy Tips to Solve Invalid URL Issues
  1. Clearing Cache. ...
  2. Disable Problematic Extensions. ...
  3. Log out from Your Google Account. ...
  4. Uninstall and Reinstall Chrome. ...
  5. Using a Different Browser might Help. ...
  6. Review Your Permission Settings. ...
  7. Fix Broken Links. ...
  8. Set Up 301 Redirects for Content Permanently Moved.
May 16, 2024

When it is needed to repair data sources? ›

A layer needs repairing if the data source it references has been moved, renamed, or deleted or is inaccessible for some other reason.

How to repair a shapefile? ›

Procedure
  1. Use the Check Geometry tool in ArcToolbox > Data Management Tools > Features. ...
  2. Run the Repair Geometry tool in ArcToolbox > Data Management Tools > Features. ...
  3. Export the data to a geodatabase, and copy it back to a new shapefile.
  4. If the data is on a network drive, copy it to a local drive.
Jul 20, 2023

How do I change the data source of a layer? ›

Changing the data source from the Layer Properties

In the Contents pane, right-click the layer. Click Properties. Go to the Source tab and click Set Data Source. Browse the new location and click OK.

Why you should fix broken links? ›

Broken links may frustrate visitors and disrupt their browsing experience. Users are less likely to stay on your site or return to it if they encounter frequent dead ends and 404 pages, which can often lead to higher bounce rates.

How can I fix a broken link for free? ›

Broken links don't automatically fix themselves since they lead to non-existent or moved resources. But don't worry, you can fix this! By setting up automatic redirects with a 301 code (permanent redirect) or a 302 code (temporary redirect), your server can guide visitors from those broken links to the right place.

How to solve a broken link? ›

Updating or removing. Updating is the simplest fix; if there's a typo in the URL, you just need to swap it out for the correct URL and the link will work as expected. Of course, this method only works if a misspelled URL was the cause of the broken link! Removing the link is also an option.

How to check broken links? ›

Method #1: Google Search Console
  1. Log in to your Google Search Console account. ...
  2. Click the site you want to monitor. ...
  3. Click Crawl, and then click Fetch as Google. ...
  4. After Google crawls the site, to access the results click Crawl, and then click Crawl Errors.

What does it mean when it says a link is broken? ›

A broken link is a hyperlink that points to a page or resource that does not exist. Most often, these linked pages were deleted or moved without a redirection set up. When the user or crawler follows a broken link, the server returns a 404 (Not found) or 410 (Gone) status code.

How do I fix a broken email link? ›

Redirect the Link

If you created a 404 (page not found) error in a link to your domain, you can use a redirect to fix your broken email link. If you're using WordPress (like most B2B web developers), you'll want to use a 301 redirect.

How do I fix links not working in Chrome? ›

If you are experiencing issues with links not working on Google Chrome, try the following troubleshooting steps:
  1. Check your internet connection. ...
  2. Clear your cache and cookies. ...
  3. Disable extensions. ...
  4. Try incognito mode. ...
  5. Update Google Chrome. ...
  6. Try a different browser.
Mar 17, 2023

Top Articles
Common Challenges Faced by React JS Development Teams (and How to Overcome Them)
How Hearing Loss Can Qualify for Disability Benefits | Atticus
Bj 사슴이 분수
Craigslist Free En Dallas Tx
Mrh Forum
Algebra Calculator Mathway
Www.politicser.com Pepperboy News
New Slayer Boss - The Araxyte
Directions To 401 East Chestnut Street Louisville Kentucky
Gunshots, panic and then fury - BBC correspondent's account of Trump shooting
Day Octopus | Hawaii Marine Life
Danielle Longet
Garrick Joker'' Hastings Sentenced
Pwc Transparency Report
Find your energy supplier
2021 Lexus IS for sale - Richardson, TX - craigslist
My.doculivery.com/Crowncork
Hartland Liquidation Oconomowoc
Truth Of God Schedule 2023
Second Chance Maryland Lottery
Der Megatrend Urbanisierung
Www Craigslist Milwaukee Wi
Byui Calendar Fall 2023
Petco Vet Clinic Appointment
Panic! At The Disco - Spotify Top Songs
Toyota Camry Hybrid Long Term Review: A Big Luxury Sedan With Hatchback Efficiency
Titanic Soap2Day
Kohls Lufkin Tx
Mineral Wells Skyward
Dmv In Anoka
Belledelphine Telegram
Marokko houdt honderden mensen tegen die illegaal grens met Spaanse stad Ceuta wilden oversteken
R Baldurs Gate 3
27 Fantastic Things to do in Lynchburg, Virginia - Happy To Be Virginia
10-Day Weather Forecast for Santa Cruz, CA - The Weather Channel | weather.com
Miles City Montana Craigslist
Nurofen 400mg Tabletten (24 stuks) | De Online Drogist
Obsidian Guard's Skullsplitter
new haven free stuff - craigslist
拿到绿卡后一亩三分地
Stanford Medicine scientists pinpoint COVID-19 virus’s entry and exit ports inside our noses
Bernie Platt, former Cherry Hill mayor and funeral home magnate, has died at 90
301 Priest Dr, KILLEEN, TX 76541 - HAR.com
Shoecarnival Com Careers
Mathews Vertix Mod Chart
From Grindr to Scruff: The best dating apps for gay, bi, and queer men in 2024
Cara Corcione Obituary
Craigslist Marshfield Mo
Slug Menace Rs3
Noelleleyva Leaks
Sunset On November 5 2023
Latest Posts
Article information

Author: Carmelo Roob

Last Updated:

Views: 6670

Rating: 4.4 / 5 (45 voted)

Reviews: 92% of readers found this page helpful

Author information

Name: Carmelo Roob

Birthday: 1995-01-09

Address: Apt. 915 481 Sipes Cliff, New Gonzalobury, CO 80176

Phone: +6773780339780

Job: Sales Executive

Hobby: Gaming, Jogging, Rugby, Video gaming, Handball, Ice skating, Web surfing

Introduction: My name is Carmelo Roob, I am a modern, handsome, delightful, comfortable, attractive, vast, good person who loves writing and wants to share my knowledge and understanding with you.