> ## Content Index > Fetch the complete content index at: https://todayfixtech.com/llms.txt > Use this file to discover other available public pages before exploring further. # How to Fix Excel External Links Not Showing - URL: https://todayfixtech.com/excel-external-links-not-showing/ - Published: 2026-10-15T04:09:12.000Z - Updated: 2026-10-15T04:09:12.000Z - Author: Md Sojib Mia - Tags: Microsoft, Troubleshooting If external links are not showing in your Excel files, it could [be due to issues](https://todayfixtech.com/fix-microsoft-365-login-issues/) like incorrect file paths or settings. Fortunately, you can troubleshoot and restore these links by following specific steps. This guide will help you resolve the problem and ensure your data consolidation runs smoothly. ## Why are my external links missing? External links may not show up in Excel for several reasons. A common cause is that the linked file has been moved or renamed, resulting in an invalid link. Additionally, Excel's settings may be configured to not display external links, especially if the workbook is set to manual calculation mode. If the external file is located in a restricted access area, Excel may also be unable to retrieve it. ## How to check your link settings To check your link settings in Excel, follow these steps: 1. Open the Excel workbook where the external links are missing. 2. Go to the `Data` tab on the ribbon. 3. Click on `Edit Links` in the Connections group. 4. In the Edit Links dialog box, you will see a list of all external links. If the links are not visible, ensure that the source files are accessible and correctly linked. 5. If the links are broken, you can attempt to update or change the source file by selecting the relevant link and clicking `Change Source...` to locate the correct file. ![The Excel data tab showing the edit links option on a computer screen.](https://tse1.mm.bing.net/th?q=Excel%20data%20tab%20with%20edit%20links%20open&w=624&h=352&c=7) ## Verifying if the links are broken To verify if your external links are broken: 1. Open the Excel workbook containing the external links. 2. Go to the `Data` tab and click on `Edit Links`. 3. In the Edit Links dialog, look for any links marked as `Error` or `Source not found`. 4. If you find any broken links, you can try to fix them by updating the source or removing them entirely. If the links show as `OK`, then they are intact, and the issue may lie elsewhere. ![An Excel workbook with an error message indicating broken links.](https://tse1.mm.bing.net/th?q=Excel%20workbook%20showing%20broken%20links%20error&w=624&h=352&c=7) ## Preventing future link issues To avoid issues with external links in the future, consider the following tips: - Keep your linked files organized in a consistent folder structure to prevent accidental moves or renames. - Always verify the links after moving files to ensure they still point to the correct source. - Use relative paths instead of absolute paths when linking to files that might be shared among different users or machines. - Regularly check your link settings in Excel, especially after updates or changes to your working environment. ## Frequently asked questions If you have more questions about external links in Excel, here are some common inquiries: - How do I update an external link in Excel? - Can I change the source of an external link? - What happens if I break a link in Excel? - How do I create new external links? ## Conclusion By following the troubleshooting steps outlined above, you should be able to restore visibility to your external links in Excel. Proper maintenance of your link settings and file structure will help prevent similar issues in the future. If problems persist, consider reaching out to your IT support for further assistance. ## Frequently Asked Questions ### How do I update an external link in Excel? To update an external link, go to the \`Data\` tab, click \`Edit Links\`, select the link you want to update, and then click \`Update Values\`. ### Can I change the source of an external link? Yes, you can change the source by selecting the link in the \`Edit Links\` dialog, then clicking \`Change Source...\` and navigating to the new file. ### What happens if I break a link in Excel? If you break a link, Excel will replace the linked data with the last known values, but you will lose the connection to the original file. ### How do I create new external links? You can create new external links by referencing a cell or range in another workbook. Simply type \`=\` in a cell, switch to the other workbook, and click on the cell you want to link.