{"id":264552,"date":"2021-06-01T17:24:46","date_gmt":"2021-06-01T14:24:46","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/"},"modified":"2021-06-01T17:24:46","modified_gmt":"2021-06-01T14:24:46","slug":"how-to-find-links-to-other-workbooks-in-microsoft-excel","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/","title":{"rendered":"#How to Find Links to Other Workbooks in Microsoft Excel"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_85 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6a358173609e8\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6a358173609e8\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/#Find_Workbook_Links_in_Formulas\" >Find Workbook Links in Formulas<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/#Find_Workbook_Links_in_Defined_Names\" >Find Workbook Links in Defined Names<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/#Find_Workbook_Links_in_Charts\" >Find Workbook Links in Charts<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/how-to-find-links-to-other-workbooks-in-microsoft-excel\/#Find_Workbook_Links_in_Objects\" >Find Workbook Links in Objects<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#How to Find Links to Other Workbooks in Microsoft Excel&#8221;<\/strong><\/p>\n<div>\n<img loading=\"lazy\" decoding=\"async\" class=\"type:primaryImage alignnone size-full wp-image-725718\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?width=1198&amp;trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Microsoft Excel logo\" width=\"1200\" height=\"555\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>One of Microsoft Excel\u2019s greatest features is the ability to link to other workbooks. So if a time comes when you need to find those workbook links that you\u2019ve included, you\u2019ll need to know where to begin.<\/p>\n<p>A <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/general\/\" data-internallinksmanager029f6b8e52c=\"3\" title=\"General\" target=\"_blank\" rel=\"noopener\">general<\/a> search to locate the links to workbooks is easy if it\u2019s just the text in the cells that you look through. But if you have workbooks linked in formulas, defined names, charts, or objects, it\u2019s not an obvious search. With a mix of built-in tools and your own two eyes, here\u2019s how to find links to your other workbooks in Microsoft Excel.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_Workbook_Links_in_Formulas\"><\/span>Find Workbook Links in Formulas<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Aside from a simple cross-reference link in some cell text, formulas are common places in which to include workbook links. After all, pulling in data from another sheet that calculates with what\u2019s in your current sheet is a powerful way to use Excel.<\/p>\n<p>Start by opening the Find feature. You can do this with Ctrl+f or Find &amp; Select &gt; Find in the ribbon on the Home tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726349\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FindSelectFind-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Find &amp; Select and pick Find\" width=\"297\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Find and Replace box opens, you\u2019ll only need to enter three pieces of information. Click \u201cOptions\u201d and enter the following:<\/p>\n<ol>\n<li><strong>Find What:<\/strong> Enter \u201c.xl\u201d<\/li>\n<li><strong>Within:<\/strong> Pick \u201cWorkbook\u201d<\/li>\n<li><strong>Look In:<\/strong> Choose \u201cFormulas\u201d<\/li>\n<\/ol>\n<p>Click \u201cFind All\u201d to obtain your results.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726351\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FindAndReplaceSettings-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Find and Replace settings, click Find All\" width=\"650\" height=\"303\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You should see your linked workbooks display under Book. You can click that column header to sort alphabetically if you have more than one workbook linked.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726350\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FindAndReplaceResults-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Find and Replace results\" width=\"650\" height=\"360\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<blockquote class=\"admonishment_tip\"><p><strong>Tip:<\/strong> You can use the Find dialog box to find workbook links in values, notes, and comments, too. Just choose one of those options instead of Formulas in the \u201cLook In\u201d drop-down list.<\/p><\/blockquote>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_Workbook_Links_in_Defined_Names\"><\/span>Find Workbook Links in Defined Names<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Another common location to have external references in Excel are cells with defined names. As you know, labeling a cell or range with a meaningful name, especially if it contains a reference link, is convenient.<\/p>\n<p>While a find-and-select dialog box for your search, like with formulas, isn\u2019t currently an option, you can pull up all defined names in your workbook. Then, just look for those workbook links.<\/p>\n<p>Go to the Formulas tab and click \u201cName Manager.\u201d<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726354\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FormulasNameManager-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to Formulas and click Name Manager\" width=\"453\" height=\"157\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>When the Name Manager window displays, you can look for workbooks in the Refers To column. Since these have the XLS or XLSX extension, you should be able to spot them easily. If necessary, you can also select one to see the entire workbook name in the Refers To box at the bottom of the window.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726353\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FormulasNameManagerResults-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Name Manager workbook results\" width=\"650\" height=\"409\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_Workbook_Links_in_Charts\"><\/span>Find Workbook Links in Charts<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>If you\u2019re using Microsoft Excel to place your data in a handy chart and you\u2019re pulling in more data from another workbook, it\u2019s pretty easy to find those links.<\/p>\n<p>Select your chart and go to the Format tab that <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>ears once you\u2019ve done so. On the far left of the ribbon, click the \u201cChart Elements\u201d drop-down box in the Current Selection section.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726357\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FormatChartElements-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Go to Format and click the Chart Elements drop-down\" width=\"388\" height=\"155\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose the data <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/watch-movies-tv-seriess\/\" data-internallinksmanager029f6b8e52c=\"8\" title=\"Watch Movies &amp; TV Series\" target=\"_blank\" rel=\"noopener\">series<\/a> from the list where you want to look for a link to a workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726356\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FormatChartSeries-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Choose a data series\" width=\"273\" height=\"369\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Then, move your eyes to the formula bar. If you have the workbook linked, you\u2019ll see it here, denoted by an Excel extension. And you can check each data series in your chart in the same way.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726355\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FormatChartSeriesResults-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Workbook linked in chart\" width=\"650\" height=\"224\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>If you believe that you have a workbook linked in a chart title rather than in a data series, just click the chart title. Then, gander at the formula bar for a Microsoft Excel workbook.<\/p>\n<h2 role=\"heading\" aria-level=\"2\"><span class=\"ez-toc-section\" id=\"Find_Workbook_Links_in_Objects\"><\/span>Find Workbook Links in Objects<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Just like inserting a PDF into an Excel sheet using an object, you can do the same for your workbooks. Unfortunately, objects make for the most tedious of items when it comes to finding links to other workbooks. But with this tip, you can speed up the process.<\/p>\n<p>Open the Go To Special dialog box. You can do this with Ctrl+g or Find &amp; Select &gt; Go To Special in the ribbon on the Home tab.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726361\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FindSelectGoToSpecial-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Click Find &amp; Select and pick Go To Special\" width=\"297\" height=\"500\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Choose \u201cObjects\u201d in the box and click \u201cOK.\u201d This will select all objects in your workbook.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726360\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/FindSelectGoToSpecialObjects-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Pick Objects and click OK\" width=\"378\" height=\"430\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>For the first object, look to the formula bar (like the one above) for charts. Then, hit the Tab key to go to the next object and do the same.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-726359\" src=\"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/05\/ObjectResults-Excel.png?trim=1,1&amp;bg-color=000&amp;pad=1,1\" alt=\"Workbook linked in object\" width=\"650\" height=\"40\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>You can continue to press Tab and look at the formula bar for each object in your workbook. When you land back on the first object that you reviewed, you\u2019ve gone through them all.<\/p>\n<p>Remember these useful tips the next time you need to find a link to a workbook in Microsoft Excel.<\/p>\n<\/div>\n<p><script>\n setTimeout(function(){\n  !function(f,b,e,v,n,t,s)\n  {if(f.fbq)return;n=f.fbq=function(){n.callMethod?\n  n.callMethod.apply(n,arguments):n.queue.push(arguments)};\n  if(!f._fbq)f._fbq=n;n.push=n;n.loaded=!0;n.version='2.0';\n  n.queue=[];t=b.createElement(e);t.async=!0;\n  t.src=v;s=b.getElementsByTagName(e)[0];\n  s.parentNode.insertBefore(t,s) } (window, document,'script',\n  'https:\/\/connect.facebook.net\/en_US\/fbevents.js');\n   fbq('init', '335401813750447');\n   fbq('track', 'PageView');\n  },3000);\n<\/script><\/p>\n<blockquote><p><strong><span style=\"color: #ff6600;\">If you liked the article, do not forget to share it with your friends. Follow us on\u00a0<span style=\"color: #ff0000;\"><a style=\"color: #ff0000;\" href=\"https:\/\/news.google.com\/publications\/CAAqBwgKMLG0nwswvr63Aw\" target=\"_blank\" rel=\"nofollow noopener noreferrer\">Google News<\/a><\/span>\u00a0too, click on the star and choose us from your favorites.<\/span><\/strong><\/p><\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.howtogeek.com\/726344\/how-to-find-links-to-other-workbooks-in-excel\/\" target=\"_blank\" rel=\"noopener\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#How to Find Links to Other Workbooks in Microsoft Excel&#8221; One of Microsoft Excel\u2019s greatest features is the ability to link to other workbooks. So if a time comes when you need to find those workbook links that you\u2019ve included, you\u2019ll need to know where to begin. A general search to locate the links to&#8230;<\/p>\n","protected":false},"author":1,"featured_media":264553,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.howtogeek.com\/wp-content\/uploads\/2021\/04\/microsoft-excel-logo.jpg?height=200p&trim=2,2,2,2","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-264552","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/264552","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=264552"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/264552\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/264553"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=264552"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=264552"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=264552"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}