{"id":5865,"date":"2025-09-05T14:22:26","date_gmt":"2025-09-05T14:22:26","guid":{"rendered":"https:\/\/pt.repairmsexcel.com\/blog\/?p=5865"},"modified":"2025-09-05T14:29:37","modified_gmt":"2025-09-05T14:29:37","slug":"excel-erro-de-tempo-de-execucao-2146-automation-error","status":"publish","type":"post","link":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error","title":{"rendered":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!"},"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 com uma planilha do Excel, voc\u00ea pode receber a mensagem \u201c<strong>run time error \u2018- 2147 automation error.<\/strong>\u201d Essa mensagem de aviso geralmente ocorre quando macros, scripts VBA ou suplementos externos n\u00e3o s\u00e3o executados corretamente. Mas a boa not\u00edcia \u00e9 que voc\u00ea pode solucionar o problema rapidamente seguindo as solu\u00e7\u00f5es corretas. Nesta publica\u00e7\u00e3o, voc\u00ea aprender\u00e1 todas as maneiras poss\u00edveis de corrigir o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel rapidamente.<!--more--><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5868\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/1.jpg\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"449\" height=\"270\" \/><\/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<h2 style=\"text-align: left;\"><strong>O que causa o erro de automa\u00e7\u00e3o 2146 no MS Excel?<\/strong><\/h2>\n<p style=\"text-align: justify;\">Bem, o <strong>erro de automa\u00e7\u00e3o -2146232576 (80131700) <\/strong>\u00e9 um erro relacionado ao VBA. Ele geralmente aparece quando o Excel n\u00e3o consegue executar um comando ou quando um objeto est\u00e1 ausente.<\/p>\n<p style=\"text-align: justify;\">Al\u00e9m disso, existem outros motivos que podem desencadear esse erro, incluindo:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Suplementos do Excel corrompidos\/desatualizados<\/li>\n<li>Conflitos com controles ActiveX<\/li>\n<li>Refer\u00eancias VBA danificadas ou bibliotecas ausentes<\/li>\n<li>Execu\u00e7\u00e3o de atualiza\u00e7\u00f5es desatualizadas do MS Office<\/li>\n<li>Corrup\u00e7\u00e3o de arquivos do sistema no Windows<\/li>\n<\/ul>\n<p style=\"text-align: justify;\">Identificar a causa exata \u00e9 essencial antes de aplicar uma corre\u00e7\u00e3o.<\/p>\n<h2 style=\"text-align: left;\"><strong>Solu\u00e7\u00f5es alternativas para corrigir o erro de tempo de execu\u00e7\u00e3o 2146 &#8211; Erro de automa\u00e7\u00e3o no Excel<\/strong><\/h2>\n<p style=\"text-align: justify;\">Aqui est\u00e3o solu\u00e7\u00f5es comprovadas para tentar resolver o erro:<\/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<ol style=\"text-align: justify;\">\n<li><strong><a href=\"#s1\">Verifique as refer\u00eancias do VBA<\/a><\/strong><\/li>\n<li><strong><a href=\"#s2\">Repare arquivos de sistema corrompidos<\/a><\/strong><\/li>\n<li><strong><a href=\"#s3\">Desative suplementos defeituosos<\/a><\/strong><\/li>\n<li><strong><a href=\"#s4\">Registre novamente os arquivos DLL<\/a><\/strong><\/li>\n<li><strong><a href=\"#s5\">Atualizando o Excel<\/a><\/strong><\/li>\n<li><strong><a href=\"#s6\">Reparando o Microsoft Office<\/a><\/strong><\/li>\n<li><strong><a href=\"#s7\">Experimente a solu\u00e7\u00e3o avan\u00e7ada: Ferramenta de reparo do Excel<\/a><\/strong><\/li>\n<\/ol>\n<\/div><\/div>\n<a name=\"s1\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 1 &#8211; Verifique as refer\u00eancias do VBA<\/strong><\/h3>\n<p style=\"text-align: justify;\">O primeiro passo que voc\u00ea precisa seguir para resolver o erro 2146 \u00e9 verificar as refer\u00eancias do VBA. Refer\u00eancias do VBA incorretas ou ausentes podem gerar erros de automa\u00e7\u00e3o. Para verificar as refer\u00eancias, siga os passos abaixo:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Abra o Excel.<\/li>\n<li>Pressione as teclas <strong>Alt + F11<\/strong> juntas para abrir o editor do VBA.<\/li>\n<li>Clique em <strong>Ferramentas &gt;&gt; Refer\u00eancias.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5869\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/2.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"596\" height=\"405\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Agora, procure as refer\u00eancias &#8220;<strong>Ausentes<\/strong>&#8221; e desmarque-as.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5870\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/3.jpg\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"445\" height=\"359\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Adicione novamente a biblioteca correta, se necess\u00e1rio.<\/li>\n<\/ul>\n<p><a name=\"s2\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 2 &#8211; Reparar Arquivos de Sistema Corrompidos<\/strong><\/h3>\n<p style=\"text-align: justify;\">Como j\u00e1 mencionado na se\u00e7\u00e3o Causas, a corrup\u00e7\u00e3o nos arquivos de sistema \u00e9 um dos principais motivos para a ocorr\u00eancia desse erro. Para corrigi-lo, tente executar uma verifica\u00e7\u00e3o SFC e reparar os arquivos de sistema do Windows.<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Pressione <strong>Windows + R<\/strong> para abrir a caixa <strong>Executar<\/strong>.<\/li>\n<li style=\"text-align: left;\">Em seguida, digite <strong>CMD<\/strong> &gt;&gt; pressione <strong>Enter<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5871\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/4.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"399\" height=\"206\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Assim que a janela do prompt de comando abrir, basta digitar <strong>sfc\/scannow<\/strong> &amp; e pressionar <strong>Enter<\/strong>.<\/li>\n<li style=\"text-align: left;\">Assim que o processo terminar, reinicie o computador e verifique se o erro persiste.<\/li>\n<\/ul>\n<p><a name=\"s3\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 3 &#8211; Desativar Suplementos com Defeito<\/strong><\/h3>\n<p style=\"text-align: justify;\">\u00c0s vezes, suplementos com defeito podem ser um problema e causar v\u00e1rios erros, incluindo o <strong>erro de automa\u00e7\u00e3o 2146 em tempo de execu\u00e7\u00e3o no Excel<\/strong>. Para verificar os suplementos com defeito e desativ\u00e1-los, siga os passos abaixo:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Mantenha pressionada a tecla <strong>CTRL<\/strong> &gt;&gt; clique em um aplicativo at\u00e9 que ele solicite o modo de seguran\u00e7a &gt;&gt; e solte a tecla CTRL.<\/li>\n<li style=\"text-align: left;\">Inicie o aplicativo Excel.<\/li>\n<li style=\"text-align: left;\">Clique em <strong>Op\u00e7\u00f5es &gt;&gt; Suplementos<\/strong><\/li>\n<li style=\"text-align: left;\">Encontre um <strong>Gerenciador: Suplementos do Excel<\/strong>, al\u00e9m disso, basta clicar em <strong>Go<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5872\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/5.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"666\" height=\"502\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Agora, desmarque a op\u00e7\u00e3o Suplementos para desabilit\u00e1-los e, em seguida, habilit\u00e1-los.<\/li>\n<\/ul>\n<p><a name=\"s4\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 4 &#8211; Registrar novamente os arquivos DLL<\/strong><\/h3>\n<p style=\"text-align: justify;\">Registrar novamente os arquivos DLL \u00e9 outra solu\u00e7\u00e3o eficaz para lidar com esses erros de tempo de execu\u00e7\u00e3o no Excel. Erros de automa\u00e7\u00e3o podem ocorrer se as DLLs obrigat\u00f3rias n\u00e3o forem registradas.<\/p>\n<ul style=\"text-align: justify;\">\n<li>Abra o <strong>Prompt de Comando como administrador.<\/strong><\/li>\n<li>Em seguida, execute o comando abaixo:<\/li>\n<\/ul>\n<blockquote>\n<p style=\"text-align: justify;\"><strong><em>regsvr32 mscomctl.ocx<\/em><\/strong><\/p>\n<\/blockquote>\n<ul style=\"text-align: justify;\">\n<li>Ap\u00f3s a conclus\u00e3o deste processo, reinicie o aplicativo Excel e verifique se o erro foi resolvido.<\/li>\n<\/ul>\n<p><a name=\"s5\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 5 &#8211; Corrigir o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o atualizando o Excel<\/strong><\/h3>\n<p style=\"text-align: justify;\">Se voc\u00ea estiver usando uma vers\u00e3o desatualizada do MS Office ou do MS Excel, essa pode ser a causa desse erro irritante. Portanto, certifique-se de que sua vers\u00e3o do MS Office ou do MS Excel esteja atualizada.<\/p>\n<p style=\"text-align: justify;\"><strong>Veja como fazer isso:<\/strong><\/p>\n<ul style=\"text-align: justify;\">\n<li>Acesse o menu <strong>Arquivo &gt;&gt; Conta &gt;&gt; Op\u00e7\u00f5es de Atualiza\u00e7\u00e3o<\/strong>.<\/li>\n<li>Selecione <strong>Atualizar Agora.<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5873\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/6.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"724\" height=\"550\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li>Instale os patches mais recentes e reinicie o Excel.<\/li>\n<\/ul>\n<p><a name=\"s6\"><\/a><\/p>\n<h3 style=\"text-align: left;\"><strong>M\u00e9todo 6 &#8211; Reparando o Microsoft Office<\/strong><\/h3>\n<p style=\"text-align: justify;\">Por \u00faltimo, mas n\u00e3o menos importante, se nenhuma das solu\u00e7\u00f5es acima funcionou, tente reparar o MS Office por conta pr\u00f3pria.<\/p>\n<p style=\"text-align: justify;\">Aqui est\u00e3o os passos a serem seguidos:<\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Abra o <strong>Painel de Controle.<\/strong><\/li>\n<li style=\"text-align: left;\">Acesse <strong>Programas &gt; Programas e Recursos<\/strong>.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5874\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/7.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"600\" height=\"246\" \/><\/p>\n<ul style=\"text-align: justify;\">\n<li style=\"text-align: left;\">Selecione <strong>Microsoft Office<\/strong> e clique em <strong>Alterar<\/strong>.<\/li>\n<li style=\"text-align: left;\">Selecione <strong>Reparo R\u00e1pido<\/strong> primeiro e, em seguida, tente o <strong>Reparo Online<\/strong>, se necess\u00e1rio.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5876\" src=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/8.png\" alt=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error \" width=\"528\" height=\"340\" \/><br \/>\n<a name=\"s7\"><\/a><\/p>\n<h2 style=\"text-align: left;\"><strong>Experimente a Solu\u00e7\u00e3o Avan\u00e7ada: Excel Reparo Ferramenta<\/strong><\/h2>\n<p style=\"text-align: justify;\">Procurando uma maneira instant\u00e2nea de resolver o erro de automa\u00e7\u00e3o -2146232576 (80131700)? Voc\u00ea pode experimentar a <a href=\"https:\/\/pt.repairmsexcel.com\/baixar-julgamento.php\" target=\"_blank\" rel=\"noopener\"><strong>MS<\/strong> <strong>Excel Reparo Ferramenta<\/strong><\/a>, recomendada profissionalmente, para reparar arquivos do Excel corrompidos, danificados e inacess\u00edveis.<\/p>\n<p style=\"text-align: justify;\">Este utilit\u00e1rio de reparo pode restaurar facilmente tudo, incluindo coment\u00e1rios de c\u00e9lulas, gr\u00e1ficos, propriedades de planilhas e outros dados relacionados, de um documento do Excel corrompido.<\/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<h2 style=\"text-align: left;\"><strong>Perguntas Frequentes:<\/strong><\/h2>\n<h4 style=\"text-align: left;\"><strong>Como Corrigir o Erro de Automa\u00e7\u00e3o no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para corrigir o erro de automa\u00e7\u00e3o no Microsoft Excel:<\/p>\n<ul style=\"text-align: justify;\">\n<li>Verifique se h\u00e1 atualiza\u00e7\u00f5es do Windows e do MS Office<\/li>\n<li>Compile o c\u00f3digo VBA<\/li>\n<li>Revise as altera\u00e7\u00f5es recentes<\/li>\n<li>Verifique as refer\u00eancias<\/li>\n<li>Redefinir o ambiente VBA<\/li>\n<li>Reinstale o Office.<\/li>\n<\/ul>\n<h4 style=\"text-align: left;\"><strong>Como corrigir erros automaticamente no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para corrigir erros automaticamente no Excel, escolha o menu <strong>Arquivo &gt; Op\u00e7\u00f5es &gt; Revis\u00e3o de Texto<\/strong>. Escolha Op\u00e7\u00f5es de Autocorre\u00e7\u00e3o &gt;&gt; escolha os erros de digita\u00e7\u00e3o mais prov\u00e1veis.<\/p>\n<h4 style=\"text-align: left;\"><strong>Como habilitar a automa\u00e7\u00e3o no Excel?<\/strong><\/h4>\n<p style=\"text-align: justify;\">Para habilitar a automa\u00e7\u00e3o no Excel, acesse Gerenciar, clique em <strong>Suplementos do Excel<\/strong> &gt;&gt; clique em <strong>Ir<\/strong>. Na caixa de di\u00e1logo Suplementos, escolha Automa\u00e7\u00e3o. Na lista de servidores COM registrados, clique no seu Suplemento de Automa\u00e7\u00e3o &gt;&gt; clique em OK.<\/p>\n<h2 style=\"text-align: left;\"><strong>Tempo de Encerramento<\/strong><\/h2>\n<p style=\"text-align: justify;\">Ap\u00f3s seguir as abordagens especificadas neste blog, voc\u00ea poder\u00e1 <strong>resolver o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel<\/strong>. No entanto, tentei o meu melhor para fornecer informa\u00e7\u00f5es apropriadas sobre essa mensagem de aviso e suas corre\u00e7\u00f5es.<\/p>\n<p style=\"text-align: justify;\">No entanto, se voc\u00ea estiver recebendo esse erro devido a uma pasta de trabalho corrompida, sugerimos que voc\u00ea tente uma ferramenta avan\u00e7ada de reparo do Excel. Isso reparar\u00e1 o arquivo corrompido do Excel e resolver\u00e1 o erro.<\/p>\n<p style=\"text-align: justify;\">Para mais d\u00favidas, visite nossa p\u00e1gina oficial no <strong><a href=\"https:\/\/www.facebook.com\/MS-Excel-Repair-Tool-1569953153234271\" target=\"_blank\" rel=\"noopener\">Facebook<\/a>.<\/strong><\/p>\n<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 com uma planilha do Excel, voc\u00ea pode receber a mensagem \u201crun time error \u2018- 2147 automation error.\u201d Essa &#8230; <\/p>\n<p class=\"read-more-container\"><a title=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\" class=\"read-more button\" href=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#more-5865\" aria-label=\"Read more about Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\">Read more<\/a><\/p>\n","protected":false},"author":2,"featured_media":5866,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[694],"tags":[1868],"class_list":["post-5865","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-erros","tag-erro-de-tempo-de-execucao-erro-de-automacao-2147","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>Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!<\/title>\n<meta name=\"description\" content=\"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.\" \/>\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-erro-de-tempo-de-execucao-2146-automation-error\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\" \/>\n<meta property=\"og:description\" content=\"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error\" \/>\n<meta property=\"og:site_name\" content=\"Excel Arquivo Reparar Blog\" \/>\n<meta property=\"article:published_time\" content=\"2025-09-05T14:22:26+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-09-05T14:29:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.png\" \/>\n\t<meta property=\"og:image:width\" content=\"550\" \/>\n\t<meta property=\"og:image:height\" content=\"310\" \/>\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=\"7 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-erro-de-tempo-de-execucao-2146-automation-error#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error\"},\"author\":{\"name\":\"Margret\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#\\\/schema\\\/person\\\/86e315631c24121ea37981cd8f9753ca\"},\"headline\":\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\",\"datePublished\":\"2025-09-05T14:22:26+00:00\",\"dateModified\":\"2025-09-05T14:29:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error\"},\"wordCount\":1112,\"publisher\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Runtime-Error-2146-Automation-Error.png\",\"keywords\":[\"erro de tempo de execu\u00e7\u00e3o - erro de automa\u00e7\u00e3o 2147\"],\"articleSection\":[\"Excel erros\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error\",\"name\":\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Runtime-Error-2146-Automation-Error.png\",\"datePublished\":\"2025-09-05T14:22:26+00:00\",\"dateModified\":\"2025-09-05T14:29:37+00:00\",\"description\":\"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage\",\"url\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Runtime-Error-2146-Automation-Error.png\",\"contentUrl\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/wp-content\\\/uploads\\\/2025\\\/09\\\/Runtime-Error-2146-Automation-Error.png\",\"width\":550,\"height\":310,\"caption\":\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\\\/excel-erro-de-tempo-de-execucao-2146-automation-error#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/pt.repairmsexcel.com\\\/blog\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!\"}]},{\"@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":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!","description":"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.","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-erro-de-tempo-de-execucao-2146-automation-error","og_locale":"en_US","og_type":"article","og_title":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!","og_description":"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.","og_url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error","og_site_name":"Excel Arquivo Reparar Blog","article_published_time":"2025-09-05T14:22:26+00:00","article_modified_time":"2025-09-05T14:29:37+00:00","og_image":[{"width":550,"height":310,"url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.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":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#article","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error"},"author":{"name":"Margret","@id":"https:\/\/pt.repairmsexcel.com\/blog\/#\/schema\/person\/86e315631c24121ea37981cd8f9753ca"},"headline":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!","datePublished":"2025-09-05T14:22:26+00:00","dateModified":"2025-09-05T14:29:37+00:00","mainEntityOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error"},"wordCount":1112,"publisher":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#organization"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.png","keywords":["erro de tempo de execu\u00e7\u00e3o - erro de automa\u00e7\u00e3o 2147"],"articleSection":["Excel erros"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error","url":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error","name":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!","isPartOf":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage"},"image":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage"},"thumbnailUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.png","datePublished":"2025-09-05T14:22:26+00:00","dateModified":"2025-09-05T14:29:37+00:00","description":"Este blog mostrar\u00e1 m\u00e9todos passo a passo para diagnosticar e corrigir rapidamente o erro de tempo de execu\u00e7\u00e3o 2146 de automa\u00e7\u00e3o no Excel.","breadcrumb":{"@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#primaryimage","url":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.png","contentUrl":"https:\/\/pt.repairmsexcel.com\/blog\/wp-content\/uploads\/2025\/09\/Runtime-Error-2146-Automation-Error.png","width":550,"height":310,"caption":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error"},{"@type":"BreadcrumbList","@id":"https:\/\/pt.repairmsexcel.com\/blog\/excel-erro-de-tempo-de-execucao-2146-automation-error#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/pt.repairmsexcel.com\/blog"},{"@type":"ListItem","position":2,"name":"Erro de tempo de execu\u00e7\u00e3o 2146 Automation Error no Excel \u2013 A solu\u00e7\u00e3o definitiva!"}]},{"@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\/5865","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=5865"}],"version-history":[{"count":3,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5865\/revisions"}],"predecessor-version":[{"id":5877,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/posts\/5865\/revisions\/5877"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media\/5866"}],"wp:attachment":[{"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/media?parent=5865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/categories?post=5865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pt.repairmsexcel.com\/blog\/wp-json\/wp\/v2\/tags?post=5865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}