{"id":331,"date":"2023-11-03T19:45:13","date_gmt":"2023-11-03T19:45:13","guid":{"rendered":"https:\/\/exceladvisor.org\/es\/actualizar\/"},"modified":"2023-12-25T10:22:45","modified_gmt":"2023-12-25T10:22:45","slug":"actualizar","status":"publish","type":"page","link":"https:\/\/exceladvisor.org\/es\/actualizar\/","title":{"rendered":"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?"},"content":{"rendered":"<div class=\"excel-antes-del-contenido\" id=\"excel-1499933094\"><script type=\"text\/javascript\">\r\n\tatOptions = {\r\n\t\t'key' : 'c1158f160081d6540a8409e6925dab94',\r\n\t\t'format' : 'iframe',\r\n\t\t'height' : 250,\r\n\t\t'width' : 300,\r\n\t\t'params' : {}\r\n\t};\r\n<\/script>\r\n<script type=\"text\/javascript\" src=\"\/\/www.highperformanceformat.com\/c1158f160081d6540a8409e6925dab94\/invoke.js\"><\/script><\/div><p>En Excel, puedes actualizar una hoja de c\u00e1lculo manualmente. Por lo general, no es necesario actualizarlo manualmente porque, de forma predeterminada, la opci\u00f3n de actualizaci\u00f3n \u00abAutom\u00e1tica\u00bb est\u00e1 seleccionada. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92708\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\" sizes=\"auto, \" srcset=\"\" alt=\"refrescar una hoja\" width=\"437\" height=\"315\"><\/figure>\n<\/div>\n<p> Pero hay formas que puede utilizar para actualizar una hoja manualmente y en este tutorial aprenderemos estos m\u00e9todos. En el siguiente ejemplo, utilizamos la funci\u00f3n ALEATORIO, que cambia su valor cuando actualiza la hoja. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92709\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/2-la-fonction-change-de-valeur-lorsque-la-feuille-est-actualisee-a-chaque-fois.png\" sizes=\"auto, \" srcset=\"\" alt=\"funci\u00f3n-cambia-valor-cuando-la-hoja-se-actualiza-cada vez\" width=\"486\" height=\"293\"><\/figure>\n<\/div>\n<h2 id=\"h-using-the-keyboard-shortcut\" class=\"wp-block-heading\"> Usando el atajo de teclado<\/h2>\n<p> Puede usar Shift+F9 (o Shift+Fn+F9) para actualizar una hoja al instante. Es r\u00e1pido y lo usas varias veces si es necesario. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92710\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/3-raccourcis-clavier-pour-referencer.png\" sizes=\"auto, \" srcset=\"\" alt=\"tecla de acceso r\u00e1pido para referencia\" width=\"292\" height=\"94\"><\/figure>\n<\/div>\n<p> Tambi\u00e9n puedes usar la tecla F9, que calcular\u00e1 el libro completo en lugar de la hoja activa. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92711\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/4-f9-pour-calculer-le-classeur-entier.png\" sizes=\"auto, \" srcset=\"\" alt=\"f9 para calcular el libro completo\" width=\"104\" height=\"100\"><\/figure>\n<\/div>\n<h2 id=\"h-using-the-calculate-sheet-option\" class=\"wp-block-heading\"> Usando la opci\u00f3n Calcular hoja<\/h2>\n<ol type=\"1\">\n<li> Navegue hasta la hoja que desea actualizar.<\/li>\n<li> Abra la pesta\u00f1a F\u00f3rmula.<\/li>\n<li> Vaya al grupo de opciones de c\u00e1lculo.<\/li>\n<li> Haga clic en la opci\u00f3n \u00abCalcular hoja\u00bb. <\/li>\n<\/ol>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92712\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/5-option-de-feuille-de-calcul.png\" sizes=\"auto, \" srcset=\"\" alt=\"opci\u00f3n-hoja-de-c\u00e1lculo\" width=\"660\" height=\"313\"><\/figure>\n<\/div>\n<p> Cuando haces clic en la opci\u00f3n, se actualiza la hoja activa y se recalculan todas tus f\u00f3rmulas.<\/p>\n<h2 id=\"h-using-a-vba-code-to-refresh-a-sheet\" class=\"wp-block-heading\"> Utilice c\u00f3digo VBA para actualizar una hoja<\/h2>\n<p> S\u00ed, puedes usar a para actualizar una hoja de c\u00e1lculo. Todo lo que tienes que hacer es abrir el editor de Visual Basic, insertar un nuevo m\u00f3dulo y luego pegar el c\u00f3digo siguiente.<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\"><strong>Sub<\/strong> Macro1() ActiveSheet.Calculate <strong>End<\/strong> <strong>Sub<\/strong><\/code><\/pre>\n<p> Y una vez que lo pegues, podr\u00e1s ejecutar el c\u00f3digo para actualizar la hoja de c\u00e1lculo con solo un clic. <\/p>\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full is-resized\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-92713\" src=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/6-vba-pour-consulter-la-feuille.png\" sizes=\"auto, \" srcset=\"\" alt=\"vba-para-actualizar-hoja\" width=\"688\" height=\"256\"><\/figure>\n<\/div>\n<p> El c\u00f3digo que tenemos arriba actualiza la hoja activa. Pero si desea actualizar una hoja espec\u00edfica, puede escribir un c\u00f3digo como el siguiente:<\/p>\n<pre class=\"wp-block-code\"> <code class=\"language-visual-basic\" lang=\"visual-basic\">Sub <strong>Macro1<\/strong> () <strong>Sheets<\/strong> (\"Sheet1\").Calculate End Sub<\/code><\/pre>\n<p> Ahora el c\u00f3digo anterior simplemente actualiza la \u00abHoja1\u00bb; Si desea cambiar el nombre, puede cambiarlo directamente desde el c\u00f3digo. <\/p>\n<div class=\"gb-container gb-container-52dfcee1 gb-container-sample-file\">\n<h2 class=\"gb-headline gb-headline-e289c143 gb-headline-text gb-headline-4f7959c2\"> Obtener el archivo Excel<\/h2>\n<p> <a class=\"gb-button gb-button-e88d6bee gb-button-text gb-button-button1\" href=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/11\/feuille-de-rafraichissement.xlsx\" rel=\"nofollow\">Descargar<\/a> <\/div>\n<div class=\"gb-container gb-container-3044ba66 gb-container-mt\">\n<p class=\"gb-headline gb-headline-b5bb6270 gb-headline-text\"> <strong><a href=\"https:\/\/exceladvisor.org\/es\/conceptos-basicos-de-excel\/\">Conceptos b\u00e1sicos de Excel<\/a><\/strong> \/ <strong><a href=\"https:\/\/exceladvisor.org\/es\/hoja-de-calculo\/\" data-wpil=\"url\">Hoja de c\u00e1lculo de Excel<\/a><\/strong><\/p>\n<h2 class=\"gb-headline gb-headline-819d540d gb-headline-text gb-headline-mt-heading\"> M\u00e1s tutoriales <\/h2>\n<div class=\"gb-grid-wrapper gb-grid-wrapper-7f3d805a gb-grid-wrapper-mt-grid\">\n<div class=\"gb-grid-column gb-grid-column-7495e031\">\n<div class=\"gb-container gb-container-7495e031\">\n<ul>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/consolidar\/\">Consolidar datos de m\u00faltiples hojas de c\u00e1lculo<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/rebautizar\/\">Cambiar nombre de hoja en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/grupo-1\/\">Hojas de trabajo grupales en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/ver-uno-al-lado-del-otro\/\">Ver dos hojas una al lado de la otra en Excel<\/a><\/li>\n<li> <a href=\"https:\/\/exceladvisor.org\/es\/agregar\/\">Agregar una hoja de c\u00e1lculo en Excel<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>En Excel, puedes actualizar una hoja de c\u00e1lculo manualmente. Por lo general, no es necesario actualizarlo manualmente porque, de forma predeterminada, la opci\u00f3n de actualizaci\u00f3n \u00abAutom\u00e1tica\u00bb est\u00e1 seleccionada. Pero hay formas que puede utilizar para actualizar una hoja manualmente y en este tutorial aprenderemos estos m\u00e9todos. En el siguiente ejemplo, utilizamos la funci\u00f3n ALEATORIO, que [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"parent":0,"menu_order":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"ub_ctt_via":"","footnotes":""},"class_list":["post-331","page","type-page","status-publish","hentry"],"featured_image_src":null,"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v25.4 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/exceladvisor.org\/es\/actualizar\/\" \/>\n<meta property=\"og:locale\" content=\"es_ES\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?\" \/>\n<meta property=\"og:description\" content=\"En Excel, puedes actualizar una hoja de c\u00e1lculo manualmente. Por lo general, no es necesario actualizarlo manualmente porque, de forma predeterminada, la opci\u00f3n de actualizaci\u00f3n \u00abAutom\u00e1tica\u00bb est\u00e1 seleccionada. Pero hay formas que puede utilizar para actualizar una hoja manualmente y en este tutorial aprenderemos estos m\u00e9todos. En el siguiente ejemplo, utilizamos la funci\u00f3n ALEATORIO, que [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/exceladvisor.org\/es\/actualizar\/\" \/>\n<meta property=\"og:site_name\" content=\"Excel Advisor\" \/>\n<meta property=\"article:modified_time\" content=\"2023-12-25T10:22:45+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Tiempo de lectura\" \/>\n\t<meta name=\"twitter:data1\" content=\"2 minutos\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/actualizar\/\",\"name\":\"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?\",\"isPartOf\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\",\"datePublished\":\"2023-11-03T19:45:13+00:00\",\"dateModified\":\"2023-12-25T10:22:45+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/#breadcrumb\"},\"inLanguage\":\"es\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/exceladvisor.org\/es\/actualizar\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage\",\"url\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/exceladvisor.org\/es\/actualizar\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Hogar\",\"item\":\"https:\/\/exceladvisor.org\/es\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#website\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"name\":\"Excel Advisor\",\"description\":\"Su gu\u00eda para la dominaci\u00f3n de datos!\",\"publisher\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/exceladvisor.org\/es\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"es\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#organization\",\"name\":\"Excel Advisor\",\"url\":\"https:\/\/exceladvisor.org\/es\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"es\",\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"contentUrl\":\"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png\",\"width\":105,\"height\":36,\"caption\":\"Excel Advisor\"},\"image\":{\"@id\":\"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/\"}}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en 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:\/\/exceladvisor.org\/es\/actualizar\/","og_locale":"es_ES","og_type":"article","og_title":"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?","og_description":"En Excel, puedes actualizar una hoja de c\u00e1lculo manualmente. Por lo general, no es necesario actualizarlo manualmente porque, de forma predeterminada, la opci\u00f3n de actualizaci\u00f3n \u00abAutom\u00e1tica\u00bb est\u00e1 seleccionada. Pero hay formas que puede utilizar para actualizar una hoja manualmente y en este tutorial aprenderemos estos m\u00e9todos. En el siguiente ejemplo, utilizamos la funci\u00f3n ALEATORIO, que [&hellip;]","og_url":"https:\/\/exceladvisor.org\/es\/actualizar\/","og_site_name":"Excel Advisor","article_modified_time":"2023-12-25T10:22:45+00:00","og_image":[{"url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","type":"","width":"","height":""}],"twitter_card":"summary_large_image","twitter_misc":{"Tiempo de lectura":"2 minutos"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/exceladvisor.org\/es\/actualizar\/","url":"https:\/\/exceladvisor.org\/es\/actualizar\/","name":"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?","isPartOf":{"@id":"https:\/\/exceladvisor.org\/es\/#website"},"primaryImageOfPage":{"@id":"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage"},"thumbnailUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","datePublished":"2023-11-03T19:45:13+00:00","dateModified":"2023-12-25T10:22:45+00:00","breadcrumb":{"@id":"https:\/\/exceladvisor.org\/es\/actualizar\/#breadcrumb"},"inLanguage":"es","potentialAction":[{"@type":"ReadAction","target":["https:\/\/exceladvisor.org\/es\/actualizar\/"]}]},{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/actualizar\/#primaryimage","url":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png","contentUrl":"https:\/\/exceladvisor.org\/wp-content\/uploads\/2023\/08\/1-referencer-une-fiche.png"},{"@type":"BreadcrumbList","@id":"https:\/\/exceladvisor.org\/es\/actualizar\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Hogar","item":"https:\/\/exceladvisor.org\/es\/"},{"@type":"ListItem","position":2,"name":"\u00bfc\u00f3mo actualizar una hoja de c\u00e1lculo en excel?"}]},{"@type":"WebSite","@id":"https:\/\/exceladvisor.org\/es\/#website","url":"https:\/\/exceladvisor.org\/es\/","name":"Excel Advisor","description":"Su gu\u00eda para la dominaci\u00f3n de datos!","publisher":{"@id":"https:\/\/exceladvisor.org\/es\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/exceladvisor.org\/es\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"es"},{"@type":"Organization","@id":"https:\/\/exceladvisor.org\/es\/#organization","name":"Excel Advisor","url":"https:\/\/exceladvisor.org\/es\/","logo":{"@type":"ImageObject","inLanguage":"es","@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/","url":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","contentUrl":"https:\/\/exceladvisor.org\/es\/wp-content\/uploads\/2023\/12\/exceladvisor.org_.png","width":105,"height":36,"caption":"Excel Advisor"},"image":{"@id":"https:\/\/exceladvisor.org\/es\/#\/schema\/logo\/image\/"}}]}},"yoast_meta":{"yoast_wpseo_title":"","yoast_wpseo_metadesc":"","yoast_wpseo_canonical":""},"_links":{"self":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/331","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/comments?post=331"}],"version-history":[{"count":1,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/331\/revisions"}],"predecessor-version":[{"id":788,"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/pages\/331\/revisions\/788"}],"wp:attachment":[{"href":"https:\/\/exceladvisor.org\/es\/wp-json\/wp\/v2\/media?parent=331"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}