{"id":2099,"date":"2020-10-15T04:46:53","date_gmt":"2020-10-15T04:46:53","guid":{"rendered":"http:\/\/pt.repairmsexcel.com\/blog\/?p=2099"},"modified":"2023-02-08T06:49:57","modified_gmt":"2023-02-08T06:49:57","slug":"excel-links-quebrados","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados","title":{"rendered":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel"},"content":{"rendered":"<div class=\"cb46ff181ce6eef70c33ac8d8c9c88c4\" data-index=\"1\" style=\"float: none; margin:0px 0 0px 0; text-align:center;\">\n<style>\r\n.leaderboard { width: 320px; height: 100px; }\r\n@media(min-width: 500px) { .leaderboard { width: 468px; height: 60px; } }\r\n@media(min-width: 800px) { .leaderboard { width: 728px; height: 90px; } }\r\n<\/style>\r\n<script async src=\"https:\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-8329139124199643\" crossorigin=\"anonymous\"><\/script>\r\n<ins class=\"adsbygoogle leaderboard\"\r\n     style=\"display:inline-block\"\r\n\t data-full-width-responsive=\"true\"\r\n     data-ad-client=\"ca-pub-8329139124199643\"\r\n     data-ad-slot=\"1972481166\"><\/ins>\r\n<script>\r\n     (adsbygoogle = window.adsbygoogle || []).push({});\r\n<\/script>\n<\/div>\n<p style=\"text-align: justify;\">Ao trabalhar na planilha do Excel, \u00e9 comum encontrar alguns dos links quebrados nos dados. No entanto, isso acontece devido a v\u00e1rios motivos imprevistos e, portanto, deve ser corrigido o mais r\u00e1pido poss\u00edvel. Nesta postagem otimizada, voc\u00ea aprender\u00e1 <strong>como encontrar links quebrados no Excel<\/strong> e como consertar links quebrados do Excel com menos esfor\u00e7o.<!--more--><\/p>\n<table style=\"height: 721px;\" width=\"971\">\n<tbody>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #77c159; color: #ffffff;\" width=\"319\">\n<h3 style=\"text-align: center;\"><span style=\"color: #ffffff;\"><strong><span style=\"text-decoration: underline;\">Maneiras de encontrar links quebrados no Excel<\/span><\/strong><\/span><\/h3>\n<\/td>\n<td style=\"background-color: #77c159;\" width=\"319\">\n<h3 style=\"text-align: center;\"><span style=\"text-decoration: underline; color: #ffffff;\"><strong>Guia passo a passo de solu\u00e7\u00f5es<\/strong><\/span><\/h3>\n<\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"text-align: justify;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>M\u00e9todo 1: usando o m\u00e9todo Localizar e substituir<\/strong><\/p>\n<\/td>\n<td style=\"text-align: justify;\" width=\"319\">Abra sua planilha do Excel &gt;&gt; pressione CTRL + F para abrir a caixa de di\u00e1logo Localizar e substituir&#8230;<strong><a href=\"#sol1\">Etapas completas<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #f3f3f3;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>M\u00e9todo 2: Atrav\u00e9s do Diagrama de Relacionamento Celular<\/strong><\/p>\n<\/td>\n<td style=\"background-color: #f3f3f3; text-align: justify;\" width=\"319\"><span style=\"font-family: inherit; font-size: inherit;\">Na barra de menus, escolha a guia Arquivos &gt; Op\u00e7\u00f5es&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol2\">Etapas completas<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td width=\"319\">\n<p style=\"text-align: left;\"><strong>M\u00e9todo 3: Usando Excel VBA<\/strong><\/p>\n<\/td>\n<td style=\"text-align: justify;\" width=\"319\">Para usar o c\u00f3digo, voc\u00ea deve adicionar uma refer\u00eancia Microsoft XML V3&#8230;<strong><a href=\"#sol3\">Etapas completas<\/a><\/strong><\/td>\n<\/tr>\n<tr style=\"text-align: justify;\">\n<td style=\"background-color: #f3f3f3;\" width=\"319\">\n<p style=\"text-align: left;\"><strong>M\u00e9todo 4: usando o comando Editar links<\/strong><\/p>\n<\/td>\n<td style=\"background-color: #f3f3f3; text-align: justify;\" width=\"319\"><span style=\"font-family: inherit; font-size: inherit;\">Abra sua planilha do Excel &gt;&gt; v\u00e1 para a faixa de dados &gt;&gt; selecione Editar links&#8230;<\/span><strong style=\"font-family: inherit; font-size: inherit;\"><a href=\"#sol4\">Etapas completas<\/a><\/strong><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify;\">Aqueles que n\u00e3o sabem o que s\u00e3o links quebrados no Excel ou o que causa esse problema em detalhes, podem simplesmente verificar os subt\u00f3picos abaixo.<\/p>\n<h2 style=\"text-align: left;\"><strong>O que \u00e9 quebrar links no Excel?<\/strong><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4144\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links.png\" alt=\"MS Excel Quebrado Links\" width=\"576\" height=\"333\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links.png 576w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-300x173.png 300w\" sizes=\"auto, (max-width: 576px) 100vw, 576px\" \/><\/p>\n<p style=\"text-align: justify;\">As c\u00e9lulas da planilha do Excel geralmente est\u00e3o vinculadas a v\u00e1rios arquivos diferentes que cont\u00eam dados relevantes, como f\u00f3rmulas, c\u00f3digos, etc. por um ou v\u00e1rios motivos. Quando esses arquivos de origem s\u00e3o exclu\u00eddos, realocados, removidos ou corrompidos, o link relacionado a uma c\u00e9lula espec\u00edfica da pasta de trabalho \u00e9 automaticamente interrompido.<\/p>\n<p style=\"text-align: justify;\">Depois disso, esses links quebrados n\u00e3o podem mais executar a fun\u00e7\u00e3o direcionada.<\/p>\n<h2 style=\"text-align: left;\"><strong>Como encontrar links quebrados no Excel?<\/strong><\/h2>\n<p><a name=\"sol1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 1- Usando o M\u00e9todo Localizar e Substituir<\/strong><\/h3>\n<p style=\"text-align: justify;\">A maneira mais f\u00e1cil de localizar links quebrados do Excel \u00e9 usando o m\u00e9todo Localizar e Substituir do Excel.<\/p>\n<p style=\"text-align: justify;\">Quando o link \u00e9 criado com o arquivo de origem, cada c\u00e9lula da planilha obt\u00e9m uma extens\u00e3o de arquivo exclusiva. Esta extens\u00e3o significa que o arquivo de origem est\u00e1 vinculado \u00e0 respectiva c\u00e9lula.<\/p>\n<p style=\"text-align: justify;\">Portanto, quando o arquivo de origem \u00e9 realocado ou exclu\u00eddo do dispositivo, a planilha come\u00e7a a mostrar<strong> erro de link quebrado do Excel.<\/strong><\/p>\n<p style=\"text-align: justify;\"><strong>Siga as etapas fornecidas abaixo para encontrar links quebrados no Excel:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Em primeiro lugar, abra sua planilha Excel que est\u00e1 mostrando problemas de link quebrado.<\/li>\n<li>Depois disso, pressione o bot\u00e3o <strong>Ctrl + F<\/strong> no teclado. Isso abrir\u00e1 a caixa de di\u00e1logo Localizar e substituir.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2107\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-1.jpg\" alt=\"encontrar links quebrados no Excel 1\" width=\"527\" height=\"395\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-1.jpg 527w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-1-300x225.jpg 300w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Na caixa de di\u00e1logo aberta de localizar e substituir, v\u00e1 para a caixa Localizar. Aqui voc\u00ea deve inserir sua respectiva extens\u00e3o de arquivo, que est\u00e1 vinculada \u00e0 c\u00e9lula.<\/li>\n<li>Agora na op\u00e7\u00e3o \u201cdentro\u201d da caixa, escolha a op\u00e7\u00e3o \u201c<strong>Pasta de trabalho<\/strong>\u201d.<\/li>\n<li>Depois disso na caixa de Look in tem que escolher a op\u00e7\u00e3o \u201c<strong>F\u00f3rmulas<\/strong>\u201d.<\/li>\n<li>Por fim, pressione o bot\u00e3o localizar todos.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2108\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-2.jpg\" alt=\"encontrar links quebrados no Excel 2\" width=\"466\" height=\"278\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-2.jpg 466w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-2-300x179.jpg 300w\" sizes=\"auto, (max-width: 466px) 100vw, 466px\" \/><\/p>\n<p style=\"text-align: justify;\">Depois de executar essas etapas, voc\u00ea obter\u00e1 facilmente links quebrados do Excel.<\/p>\n<p style=\"text-align: justify;\">Agora voc\u00ea tem que substituir o problema de ter um link pelo novo link funcional ou correto.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2109\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-3.jpg\" alt=\"encontrar links quebrados no Excel 3\" width=\"762\" height=\"378\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-3.jpg 762w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-3-300x149.jpg 300w\" sizes=\"auto, (max-width: 762px) 100vw, 762px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>Leia tamb\u00e9m: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-encontrar-e-substituir-nao-trabalhando\" target=\"_blank\" rel=\"noopener noreferrer\">6 maneiras de corrigir o problema de localiza\u00e7\u00e3o e substitui\u00e7\u00e3o do Excel que n\u00e3o funciona<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"sol2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 2- Atrav\u00e9s diagrama de relacionamento celular<\/strong><\/h3>\n<p style=\"text-align: justify;\"><strong>O diagrama de relacionamento da c\u00e9lula do Excel<\/strong> \u00e9 usado principalmente para elaborar associa\u00e7\u00f5es de links de qualquer c\u00e9lula de planilha espec\u00edfica com outras c\u00e9lulas, planilhas ou qualquer pasta de trabalho.<\/p>\n<p style=\"text-align: justify;\">Para localizar os links quebrados do Excel usando o diagrama de relacionamento da c\u00e9lula, voc\u00ea precisa adicionar um suplemento espec\u00edfico \u00e0 pasta de trabalho do Excel. Depois disso, apenas o diagrama de relacionamento da c\u00e9lula mostrar\u00e1 os detalhes da liga\u00e7\u00e3o da c\u00e9lula.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o as etapas para encontrar <strong>links quebrados no Excel<\/strong> usando o diagrama de relacionamento da c\u00e9lula:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Na barra de menus, escolha a guia <strong>Arquivos<\/strong>&gt; <strong>Op\u00e7\u00f5es<\/strong>.<\/li>\n<li>Na janela aberta de op\u00e7\u00f5es do Excel, clique na guia Add-ins.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2110\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-4.jpg\" alt=\"encontrar links quebrados no Excel 4\" width=\"527\" height=\"442\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-4.jpg 527w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-4-300x252.jpg 300w\" sizes=\"auto, (max-width: 527px) 100vw, 527px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, no menu suspenso, escolha o suplemento COM e pressione o bot\u00e3o ok. Na caixa de di\u00e1logo do Add-in aberta, escolha \u201c<strong>Inquire<\/strong>\u201d.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2111\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-5.jpg\" alt=\"encontrar links quebrados no Excel 5\" width=\"621\" height=\"265\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-5.jpg 621w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-5-300x128.jpg 300w\" sizes=\"auto, (max-width: 621px) 100vw, 621px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Depois disso, voc\u00ea ver\u00e1 que a guia Inquire ser\u00e1 adicionada \u00e0 Faixa de <strong>Op\u00e7\u00f5es do Excel<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2112\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-6.jpg\" alt=\"encontrar links quebrados no Excel 6\" width=\"704\" height=\"148\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-6.jpg 704w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/find-excel-broken-links-6-300x63.jpg 300w\" sizes=\"auto, (max-width: 704px) 100vw, 704px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>No <strong>grupo de diagramas<\/strong>, voc\u00ea deve escolher <strong>Relacionamento de c\u00e9lula<\/strong>.<\/li>\n<li>A pr\u00f3xima janela do <strong>diagrama de relacionamento da c\u00e9lula<\/strong> aparecer\u00e1 na tela.<\/li>\n<li>Escolha as op\u00e7\u00f5es desejadas na caixa de di\u00e1logo aberta e pressione o bot\u00e3o <strong>OK<\/strong>.<\/li>\n<li>Muito em breve voc\u00ea ver\u00e1 que o diagrama come\u00e7ar\u00e1 a aparecer na tela do Excel.<\/li>\n<li>Voc\u00ea pode ampliar para ver os links entre uma c\u00e9lula para outra c\u00e9lula ou uma c\u00e9lula para outra planilha.<\/li>\n<li>Aqui voc\u00ea ver\u00e1 todo o diagrama de relacionamento da c\u00e9lula com todos os links inclu\u00eddos. Neste diagrama, voc\u00ea tamb\u00e9m pode verificar os links quebrados presentes em sua pasta de trabalho do Excel.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Achei esse m\u00e9todo a melhor maneira de encontrar a c\u00e9lula com os <strong>links quebrados do Excel<\/strong>.<\/p>\n<p><a name=\"sol3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 3- Usando Excel VBA<\/strong><\/h3>\n<p style=\"text-align: justify;\">Outro m\u00e9todo para localizar o link quebrado do Excel \u00e9 usar o VBA do Excel. Neste m\u00e9todo, usaremos o c\u00f3digo massivo para rastrear o link quebrado relacionado com qualquer c\u00e9lula da pasta de trabalho do Excel.<\/p>\n<p style=\"text-align: justify;\">Voc\u00ea tamb\u00e9m pode restaurar o valor de retorno dos links de origem de acesso para descobrir se os links est\u00e3o realmente quebrados ou n\u00e3o.<\/p>\n<p style=\"text-align: justify;\">Para usar o c\u00f3digo, voc\u00ea deve adicionar a refer\u00eancia Microsoft XML V3:<\/p>\n<div class=\"su-note\"  style=\"border-color:#dad9d9;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\"><div class=\"su-note-inner su-u-clearfix su-u-trim\" style=\"background-color:#f4f3f3;border-color:#ffffff;color:#333333;border-radius:2px;-moz-border-radius:2px;-webkit-border-radius:2px;\">\n<p style=\"text-align: justify;\"><em>Private Function CheckHyperlink(HypelinksCell As Range) As String<\/em><\/p>\n<p style=\"text-align: justify;\"><em>On Error GoTo ErrorHandler<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Dim oHttp As New MSXML2.XMLHTTP30<\/em><\/p>\n<p style=\"text-align: justify;\"><em>oHttp.Open &#8220;HEAD&#8221;, HypelinksCell.Text, False<\/em><\/p>\n<p style=\"text-align: justify;\"><em>oHttp.send<\/em><\/p>\n<p style=\"text-align: justify;\"><em>CheckHyperlink = oHttp.Status &amp; &#8221; &#8221; &amp; oHttp.statusText<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Exit Function<\/em><\/p>\n<p style=\"text-align: justify;\"><em>ErrorHandler:<\/em><\/p>\n<p style=\"text-align: justify;\"><em>CheckHyperlink = &#8220;Error: &#8221; &amp; Err.Description<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Function<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Sub Test()<\/em><\/p>\n<p style=\"text-align: justify;\"><em>Debug.Print CheckHyperlink(Range(&#8220;A1&#8221;))<\/em><\/p>\n<p style=\"text-align: justify;\"><em>End Sub<\/em><\/p>\n<\/div><\/div>\n<p style=\"text-align: justify;\">Usando o c\u00f3digo fornecido acima, voc\u00ea pode rastrear facilmente os detalhes do link quebrado de qualquer c\u00e9lula da planilha. Depois de saber a localiza\u00e7\u00e3o exata do link quebrado, agora proceda para consertar o link quebrado do Excel.<\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>Leia tamb\u00e9m: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/corrigir-links-de-edicao-do-excel-nao-funcionando\" target=\"_blank\" rel=\"noopener\">Como corrigir o erro do Excel \u201cN\u00e3o podemos atualizar alguns dos links\u201d?<\/a><\/strong><\/p>\n<\/blockquote>\n<p><a name=\"sol4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 4- Usando o comando Edit Links<\/strong><\/h3>\n<p style=\"text-align: justify;\">Al\u00e9m dos tr\u00eas m\u00e9todos eficazes acima, h\u00e1 outra op\u00e7\u00e3o para encontrar links quebrados nas c\u00e9lulas do Excel, que \u00e9 usar o comando editar links.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e1 como voc\u00ea pode fazer isso:<\/p>\n<ul>\n<li style=\"text-align: left;\">Abra sua planilha do Excel que cont\u00e9m links quebrados &gt;&gt; v\u00e1 para a faixa de op\u00e7\u00f5es <strong>Dados<\/strong> e selecione <strong>Editar links<\/strong>. Agora, uma caixa de di\u00e1logo aparecer\u00e1 em sua tela.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4145\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/1-1.png\" alt=\"Usando o comando Edit Links\" width=\"767\" height=\"675\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/1-1.png 767w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/1-1-300x264.png 300w\" sizes=\"auto, (max-width: 767px) 100vw, 767px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Em uma guia Origem, voc\u00ea encontrar\u00e1 todas as pastas de trabalho associadas \u00e0s c\u00e9lulas em sua pasta de trabalho atual.<\/li>\n<li style=\"text-align: left;\">Depois disso, pressione em Verificar status que voc\u00ea pode ver no lado direito.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4146\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/2-1.png\" alt=\"Usando o comando Edit Links\" width=\"788\" height=\"588\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/2-1.png 788w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/2-1-300x224.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/2-1-768x573.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Aqui, se o status estiver mostrando &#8216;<strong>Fonte est\u00e1 aberta<\/strong>&#8216;, significa simplesmente que uma pasta de trabalho consistente est\u00e1 ativa e abra-a agora.<\/li>\n<li style=\"text-align: left;\">Ap\u00f3s isso, clique na op\u00e7\u00e3o \u201c<strong>Alterar Fontes<\/strong>\u201d.<\/li>\n<li style=\"text-align: left;\">Agora, um navegador de arquivos \u00e9 aberto.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-4147\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/3-1.png\" alt=\"Usando o comando Edit Links\" width=\"788\" height=\"636\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/3-1.png 788w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/3-1-300x242.png 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/3-1-768x620.png 768w\" sizes=\"auto, (max-width: 788px) 100vw, 788px\" \/><\/p>\n<ul>\n<li style=\"text-align: left;\">Escolha um arquivo de origem de uma pasta de trabalho consistente &gt;&gt; pressione <strong>OK<\/strong>.<\/li>\n<li style=\"text-align: left;\">Neste momento, clique na op\u00e7\u00e3o <strong>Verificar<\/strong> status novamente e agora voc\u00ea n\u00e3o ver\u00e1 nenhum erro na barra de status que est\u00e1 em uma caixa de <strong>di\u00e1logo Editar links<\/strong>.<\/li>\n<\/ul>\n<h2 style=\"text-align: left;\"><strong>O que causa links quebrados no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\"><strong>Importante:<\/strong><\/p>\n<p style=\"text-align: justify;\">Sempre tenha isso em mente que os objetos vinculados s\u00e3o completamente diferentes dos hiperlinks. Portanto, o procedimento a seguir n\u00e3o ajudar\u00e1 voc\u00ea a corrigir hiperlinks corrompidos do Excel.<\/p>\n<p style=\"text-align: justify;\">Principalmente, h\u00e1 dois motivos poss\u00edveis associados ao problema de links quebrados do Excel:<\/p>\n<ul style=\"text-align: justify;\">\n<li><strong>A pasta de origem \u00e9 exclu\u00edda<\/strong>: Ap\u00f3s a exclus\u00e3o da pasta de origem, \u00e9 imposs\u00edvel rastrear os dados vinculados \u00e0 c\u00e9lula.<\/li>\n<li><strong>Arquivos \/ pastas mudados para outro local<\/strong>: Este problema de link quebrado do Excel tamb\u00e9m surge quando o local do arquivo ou pasta vinculado \u00e9 realocado.<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Depois de saber sobre as causas dos links quebrados do Excel, vamos passar ao nosso pr\u00f3ximo t\u00f3pico sobre <strong>como encontrar links quebrados no Excel.<\/strong><\/p>\n<h2 style=\"text-align: left;\"><strong>Como corrigir links quebrados no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Cuidado: esta etapa n\u00e3o pode ser revertida, portanto, ser\u00e1 melhor manter a c\u00f3pia de backup de sua pasta de trabalho do Excel antes de iniciar o procedimento.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Abra sua pasta de trabalho do Excel com o problema de link quebrado.<\/li>\n<li>V\u00e1 para a guia <strong>Dados<\/strong> e toque na op\u00e7\u00e3o <strong>Editar Links<\/strong>. Se voc\u00ea n\u00e3o obtiver a op\u00e7\u00e3o <strong>Editar links<\/strong>, significa que sua pasta de trabalho n\u00e3o cont\u00e9m nenhum link.<\/li>\n<li>Agora, na caixa Arquivo de origem, escolha o link quebrado que voc\u00ea precisa corrigir.<\/li>\n<li>Clique na op\u00e7\u00e3o <strong>Alterar fonte<\/strong>.<\/li>\n<li>Pesquise a localiza\u00e7\u00e3o do arquivo Excel com a fonte de seus dados vinculados.<\/li>\n<li>Agora escolha o novo arquivo de origem e clique na op\u00e7\u00e3o <strong>Alterar origem<\/strong>.<\/li>\n<li>Toque na op\u00e7\u00e3o <strong>Fechar<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-2113\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Fix-Broken-Links-In-Excel-1024x576.jpg\" alt=\"corrigir links quebrados no Excel\" width=\"1024\" height=\"576\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Fix-Broken-Links-In-Excel-1024x576.jpg 1024w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Fix-Broken-Links-In-Excel-300x169.jpg 300w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Fix-Broken-Links-In-Excel-768x432.jpg 768w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Fix-Broken-Links-In-Excel.jpg 1280w\" sizes=\"auto, (max-width: 1024px) 100vw, 1024px\" \/><\/p>\n<h2 style=\"text-align: left;\"><strong>Como remover link quebrado no Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Quando voc\u00ea quebra qualquer v\u00ednculo no Excel, todas as f\u00f3rmulas referentes a esse arquivo de origem espec\u00edfico s\u00e3o convertidas automaticamente para seu valor atual. Suponha que voc\u00ea tenha usado a f\u00f3rmula = SUM ([Or\u00e7amento.xls] Anual! C10: C25) e seu resultado for 45, ent\u00e3o sua f\u00f3rmula ser\u00e1 convertida para 45 ap\u00f3s quebrar o link.<\/p>\n<p style=\"text-align: justify;\">Siga as etapas abaixo para <strong><a href=\"https:\/\/support.microsoft.com\/en-us\/office\/update-or-remove-a-broken-link-to-an-external-file-29485589-816e-4841-81b7-ff90ae5a2cc4\" target=\"_blank\" rel=\"noopener nofollow\">remover links quebrados no Excel<\/a>:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Abra a pasta de trabalho do Excel mostrando o link quebrado.<\/li>\n<li>Agora v\u00e1 para a guia <strong>Dados<\/strong>, clique no bot\u00e3o <strong>Editar Links<\/strong>.<\/li>\n<li>Na caixa <strong>Arquivo de origem<\/strong>, escolha o link quebrado que voc\u00ea precisa remover.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2114\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-1.jpg\" alt=\"remover link quebrado no Excel 1\" width=\"665\" height=\"399\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-1.jpg 665w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-1-300x180.jpg 300w\" sizes=\"auto, (max-width: 665px) 100vw, 665px\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Aperte o bot\u00e3o <strong>Quebrar link<\/strong>.<\/li>\n<li>Toque na op\u00e7\u00e3o <strong>Fechar<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-2115\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-2.jpg\" alt=\"remover link quebrado no Excel 2\" width=\"518\" height=\"277\" srcset=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-2.jpg 518w, https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Remove-Broken-Link-In-Excel-2-300x160.jpg 300w\" sizes=\"auto, (max-width: 518px) 100vw, 518px\" \/><\/p>\n<blockquote>\n<p style=\"text-align: center;\"><strong>Leia tamb\u00e9m: <a href=\"https:\/\/pt.repairmsexcel.com\/blog\/resolver-excel-hyperlinks-nao-trabalhando\" target=\"_blank\" rel=\"noopener\">3 maneiras de corrigir o problema de hiperlinks do Excel que n\u00e3o est\u00e3o funcionando<\/a><\/strong><\/p>\n<\/blockquote>\n<h2 style=\"text-align: left;\"><strong>Como reparar arquivo corrompido do Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Se, de alguma forma, o seu arquivo do Excel for corrompido, voc\u00ea poder\u00e1 usar a melhor e recomendada <a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\"><strong>MS Excel Reparar Ferramenta<\/strong><\/a>. Ele tem a capacidade de reparar e recuperar arquivos do Excel corrompidos ou inacess\u00edveis.<\/p>\n<p style=\"text-align: justify;\">Mesmo que ele possa resolver diferentes problemas e erros relacionados ao Excel e restaurar dados inteiros, como gr\u00e1ficos, coment\u00e1rios de c\u00e9lulas de propriedades de planilhas, etc.<\/p>\n<center><div style='margin: 5px 15px 15px 0;'><a style='background: #3bc949; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><span style='color: #ffffff;'><i class='fab fa-windows'><\/i><\/span> Baixar<\/a> &nbsp;&nbsp;&nbsp;&nbsp;&nbsp;<a style='background: #FAB152; border-radius: 25px; color: #ffffff; cursor: pointer; display: inline-block; font-size: 20px; font-weight: 500; padding: 2px 20px; height: 40px; line-height: 40px; vertical-align: middle; white-space: nowrap; text-decoration: none; border: none;' href='https:\/\/pt.repairmsexcel.com\/blog\/compre-agora' target='_blank'><span style='color: #ffffff;'><i class='fas fa-cart-plus'><\/i><\/span> Compre Agora<\/a><\/div><div style='margin: 5px 0 10px 0; font-size: 13px;'><font color='red'>*<\/font> A vers\u00e3o gratuita do produto exibe apenas dados recuper\u00e1veis.<\/div><\/center>\n<p style=\"text-align: justify;\">Portanto, baixe esta ferramenta no seu PC e siga as etapas abaixo para saber <strong>como reparar facilmente arquivos corrompidos do Excel<\/strong>.<\/p>\n<p style='text-align: justify;'><b>Etapa 1<\/b> - Baixe e instale o <b>Stellar Reparar para Excel<\/b> seguindo o assistente de instala\u00e7\u00e3o.<\/p>\n<p style='text-align: justify;'><img class='aligncenter size-full wp-image-10203' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/10\/step1.png' alt='excel-Reparar-step-1' height='300' \/><\/p>\n<p style='text-align: justify;'><b>Etapa 2<\/b> \u2013 Ap\u00f3s a instala\u00e7\u00e3o, inicie a ferramenta de reparo e navegue at\u00e9 o arquivo Excel que deseja reparar.<\/p>\n<p style='text-align: justify;'><img class='aligncenter size-full wp-image-10203' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/10\/step2.png' alt='excel-Reparar-step-2' width='600' \/><\/p>\n<p style='text-align: justify;'><b>Etapa 3<\/b> \u2013 Agora selecione o arquivo Excel que deseja reparar e clique no bot\u00e3o '<b>Repair<\/b>'.<\/p>\n<p style='text-align: justify;'><img class='aligncenter size-full wp-image-10203' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/10\/step3.png' alt='excel-Reparar-step-3' width='600' \/><\/p>\n<p style='text-align: justify;'><b>Etapa 4<\/b> \u2013 Espere at\u00e9 que o processo de reparo termine.<\/p>\n<p style='text-align: justify;'><img class='aligncenter size-full wp-image-10203' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/10\/step4.png' alt='excel-Reparar-step-4' width='600' \/><\/p>\n<p style='text-align: justify;'><b>Etapa 5<\/b> \u2013 Uma vez feito isso, visualize e verifique o arquivo do Excel reparado e clique no bot\u00e3o '<b>Save<\/b>'.<\/p>\n<p style='text-align: justify;'><img class='aligncenter size-full wp-image-10203' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/10\/step5.png' alt='excel-Reparar-step-5' width='600' \/><\/p>\n<h2 style=\"text-align: justify;\"><strong><u>Embrulhar Up:<\/u><\/strong><\/h2>\n<p style=\"text-align: justify;\">Se sua pasta de trabalho do Excel tiver um link com os dados presentes em uma pasta de trabalho ou qualquer outro arquivo que seja movido para algum outro local. Nesse caso, voc\u00ea pode <strong>corrigir link quebrado do Excel<\/strong> problema atualizando o local do arquivo de origem na c\u00e9lula vinculada.<\/p>\n<p style=\"text-align: justify;\">Mas, se voc\u00ea n\u00e3o encontrar o arquivo de origem, pare imediatamente o Excel para atualizar o link e remova-o permanentemente.<\/p>\n<p style=\"text-align: justify;\"><br><center><a href='https:\/\/pt.repairmsexcel.com\/blog\/livre-baixar-para-win' target='_blank'><img class='pt-cta-729' src='https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2017\/08\/729x120-pt.png' \/><\/a><\/center><br>\n\n<div style=\"font-size: 0px; height: 0px; line-height: 0px; margin: 0; padding: 0; clear: both;\"><\/div>","protected":false},"excerpt":{"rendered":"<p>Ao trabalhar na planilha do Excel, \u00e9 comum encontrar alguns dos links quebrados nos dados. No entanto, isso acontece devido &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#more-2099\" aria-label=\"Read more about MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":2117,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[920,919,916,918,917,915,1373,922],"class_list":["post-2099","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-consertar-links-quebrados-do-excel","tag-encontrar-links-quebrados-no-excel","tag-excel-break-links-nao-trabalhando","tag-excel-verifica-links-quebrados","tag-links-quebrados-do-excel","tag-links-quebrados-no-excel","tag-localizar-vinculos-externos-excel","tag-remover-links-quebrados-no-excel","resize-featured-image"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel<\/title>\n<meta name=\"description\" content=\"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel\" \/>\n<meta property=\"og:description\" content=\"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-10-15T04:46:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-02-08T06:49:57+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png\" \/>\n\t<meta property=\"og:image:width\" content=\"768\" \/>\n\t<meta property=\"og:image:height\" content=\"432\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Margret\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@https:\/\/twitter.com\/margret1_arthur\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Margret\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"10 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"MS Excel Quebrado Links: Como remover\\\/encontrar links quebrados no Excel\",\"datePublished\":\"2020-10-15T04:46:53+00:00\",\"dateModified\":\"2023-02-08T06:49:57+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados\"},\"wordCount\":1824,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Excel-Broken-Links-pt.png\",\"keywords\":[\"consertar links quebrados do Excel\",\"encontrar links quebrados no Excel\",\"excel break links n\u00e3o trabalhando\",\"Excel verifica links quebrados\",\"Links quebrados do Excel\",\"links quebrados no Excel\",\"localizar vinculos externos excel\",\"remover links quebrados no Excel\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados\",\"name\":\"MS Excel Quebrado Links: Como remover\\\/encontrar links quebrados no Excel\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Excel-Broken-Links-pt.png\",\"datePublished\":\"2020-10-15T04:46:53+00:00\",\"dateModified\":\"2023-02-08T06:49:57+00:00\",\"description\":\"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Excel-Broken-Links-pt.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2020\\\/10\\\/Excel-Broken-Links-pt.png\",\"width\":768,\"height\":432,\"caption\":\"Excel Links quebrados\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-links-quebrados#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS Excel Quebrado Links: Como remover\\\/encontrar links quebrados no Excel\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"name\":\"Excel Arquivo Reparar Blog\",\"description\":\"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas\",\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\",\"name\":\"Excel Arquivo Reparar\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2021\\\/06\\\/repairmsexcel.com-logo.png\",\"width\":350,\"height\":70,\"caption\":\"Excel Arquivo Reparar\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\",\"name\":\"Margret\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g\",\"caption\":\"Margret\"},\"description\":\"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.\",\"sameAs\":[\"https:\\\/\\\/www.linkedin.com\\\/in\\\/margret-arthur-2545b6195\\\/\",\"https:\\\/\\\/x.com\\\/https:\\\/\\\/twitter.com\\\/margret1_arthur\"],\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/author\\\/margret\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel","description":"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados","og_locale":"en_US","og_type":"article","og_title":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel","og_description":"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2020-10-15T04:46:53+00:00","article_modified_time":"2023-02-08T06:49:57+00:00","og_image":[{"width":768,"height":432,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png","type":"image\/png"}],"author":"Margret","twitter_card":"summary_large_image","twitter_creator":"@https:\/\/twitter.com\/margret1_arthur","twitter_misc":{"Written by":"Margret","Est. reading time":"10 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel","datePublished":"2020-10-15T04:46:53+00:00","dateModified":"2023-02-08T06:49:57+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados"},"wordCount":1824,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png","keywords":["consertar links quebrados do Excel","encontrar links quebrados no Excel","excel break links n\u00e3o trabalhando","Excel verifica links quebrados","Links quebrados do Excel","links quebrados no Excel","localizar vinculos externos excel","remover links quebrados no Excel"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados","name":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png","datePublished":"2020-10-15T04:46:53+00:00","dateModified":"2023-02-08T06:49:57+00:00","description":"Saiba o que \u00e9 esse link quebrado do Excel ou o que causa links quebrados no Excel. Aprenda como localizar links quebrados no Excel e como remover Excel links quebrados.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2020\/10\/Excel-Broken-Links-pt.png","width":768,"height":432,"caption":"Excel Links quebrados"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-links-quebrados#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"MS Excel Quebrado Links: Como remover\/encontrar links quebrados no Excel"}]},{"@type":"WebSite","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website","url":"https:\/\/pt.repairmsexcel.com\/blog\/","name":"Excel Arquivo Reparar Blog","description":"Obter Dicas, Truques e Corre\u00e7\u00f5es por MS Excel Problemas","publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/pt.repairmsexcel.com\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization","name":"Excel Arquivo Reparar","url":"https:\/\/pt.repairmsexcel.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2021\/06\/repairmsexcel.com-logo.png","width":350,"height":70,"caption":"Excel Arquivo Reparar"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca","name":"Margret","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/ea29aef135486ebd58839d5510cb4413e8e5d6bbad7d2e01f4c06666b206df19?s=96&d=mm&r=g","caption":"Margret"},"description":"Margret Arthur \u00e9 um empreendedor e especialista em marketing de conte\u00fado. Ela escreve blogs t\u00e9cnicos e conhecimentos sobre MS Office, Excel e outros assuntos t\u00e9cnicos. Dela arte distinta de apresentar informa\u00e7\u00f5es t\u00e9cnicas em linguagem f\u00e1cil de entender \u00e9 muito impressionante. Quando n\u00e3o est\u00e1 escrevendo, ela adora viagens n\u00e3o planejadas.","sameAs":["https:\/\/www.linkedin.com\/in\/margret-arthur-2545b6195\/","https:\/\/x.com\/https:\/\/twitter.com\/margret1_arthur"],"url":"https:\/\/pt.repairmsexcel.com\/blog\/author\/margret"}]}},"_links":{"self":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2099","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/comments?post=2099"}],"version-history":[{"count":9,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2099\/revisions"}],"predecessor-version":[{"id":4149,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/2099\/revisions\/4149"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/2117"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=2099"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=2099"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=2099"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}