{"id":263811,"date":"2024-03-13T20:08:19","date_gmt":"2024-03-13T19:08:19","guid":{"rendered":"https:\/\/www.sheetgo.com\/?p=263811"},"modified":"2026-10-08T15:33:54","modified_gmt":"2026-10-08T13:33:54","slug":"conexoes-excel","status":"publish","type":"post","link":"https:\/\/www.sheetgo.com\/pt\/blog\/excel-features\/excel-connections\/","title":{"rendered":"Conex\u00f5es do Excel: obtenha dados de fontes externas"},"content":{"rendered":"<p>[et_pb_section fb_built=&#8221;1&#8243; admin_label=&#8221;section&#8221; _builder_version=&#8221;4.16&#8243; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221; da_is_popup=&#8221;off&#8221; da_exit_intent=&#8221;off&#8221; da_has_close=&#8221;on&#8221; da_alt_close=&#8221;off&#8221; da_dark_close=&#8221;off&#8221; da_not_modal=&#8221;on&#8221; da_is_singular=&#8221;off&#8221; da_with_loader=&#8221;off&#8221; da_has_shadow=&#8221;on&#8221; da_disable_devices=&#8221;off|off|off&#8221;][et_pb_row admin_label=&#8221;row&#8221; _builder_version=&#8221;4.16&#8243; background_size=&#8221;initial&#8221; background_position=&#8221;top_left&#8221; background_repeat=&#8221;repeat&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_column type=&#8221;4_4&#8243; _builder_version=&#8221;4.16&#8243; custom_padding=&#8221;|||&#8221; global_colors_info=&#8221;{}&#8221; custom_padding__hover=&#8221;|||&#8221; theme_builder_area=&#8221;post_content&#8221;][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Excel is the go-to application for data storage and management. Although it offers many features for advanced analysis and structuring data, you may need to work on larger datasets that need to be stored externally. For example, you own a cloud computing company and use another website for storage.<\/p>\n<p>As with any database, you\u2019d have to update it regularly. To do this manually by moving or copying the information would be time-consuming, and there is a greater risk of human error. Setting up data connections in Excel will allow you to create links between different data sources, including Microsoft Access or SQL databases, and automate data refresh.<\/p>\n<p>In this article, you\u2019ll learn what Excel external data connections are and how to use them in Excel. In a few simple steps, you\u2019ll be able to create your external connections in Excel, change or update the source, and remove this connection when you no longer need it. Alternatively, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered data automation platform, lets you set up and manage connections between data sources in one place.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;what-are-excel-connections&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>What are Excel connections?<\/h2>\n<p>Connections in Excel can be of two types, internal or external. Whereas the first type links to data in another workbook, the external connection in Excel can link to another file type or database. Once Excel can access the data, you can automate updates or change the data source.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-do-you-use-connections-in-excel&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How do you use connections in Excel?<\/h2>\n<p>External connections in Excel can link to Microsoft servers, such as SQL and Access Databases, or any other server where you store data. Using the Get External Data and Connections features, you can create and manage connections easily.<\/p>\n<p>Let\u2019s start by creating an external data connection in Excel.<\/p>\n<h3>How do I create a data connection in Excel?<\/h3>\n<p>In a few simple steps, you can connect an external data source to your Excel workbook.<\/p>\n<p><strong>1.<\/strong> Open an Excel workbook and go to Data &gt; Get Data.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-get-data-menu.webp&#8221; alt=&#8221;Excel connections \u2014 Get Data menu open on the Data tab with From File, From Database and From Azure&#8221; title_text=&#8221;Get Data menu open on the Data tab with From File, From Database and From Azure&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> From the drop-down menu, select the source you would like to connect to. Here, I\u2019ve selected \u201cFrom Microsoft Access Database\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-from-access-database.webp&#8221; alt=&#8221;Excel connections \u2014 From Database submenu with From Microsoft Access Database highlighted&#8221; title_text=&#8221;From Database submenu with From Microsoft Access Database highlighted&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Note that the steps may differ from now on if you have chosen a different data source. For example, if you have data stored in an SQL server, then you need to provide the address for that specific server. To learn more about creating external connections in Excel, take a look at this <a href=\"https:\/\/support.microsoft.com\/en-us\/office\/create-edit-and-manage-connections-to-external-data-89d44137-f18d-49cf-953d-d22a2eea2d46\" rel=\"noreferrer noopener\" target=\"_blank\">Microsoft Support page<\/a>.<\/p>\n<p><strong>3.<\/strong> From the \u201cImport Data\u201d dialog box, select the Access file to import. Click \u201cOpen\u201d to begin the import process.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-import-data-select-access-file.webp&#8221; alt=&#8221;Excel connections \u2014 Import Data dialog with an Access database file selected&#8221; title_text=&#8221;Import Data dialog with an Access database file selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Excel launches the \u201cNavigator\u201d pane, so you can select the table to import from the database. Click on the desired data table on the left-side list to preview.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-navigator-pane.webp&#8221; alt=&#8221;Excel connections \u2014 Navigator pane listing the database tables with no item selected&#8221; title_text=&#8221;Navigator pane listing the database tables with no item selected&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> In case you would like to preview more than one table, tick the \u201cSelect multiple items\u201d right below the search bar.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-navigator-select-multiple-items.webp&#8221; alt=&#8221;Excel connections \u2014 Navigator with Select multiple items ticked&#8221; title_text=&#8221;Navigator with Select multiple items ticked&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> At this point, you can \u201cLoad\u201d to import the data, or you can make any changes if needed. Select \u201cTransform Data\u201d to make changes.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-navigator-transform-data.webp&#8221; alt=&#8221;Excel connections \u2014 Navigator preview of Open Tasks with the Load and Transform Data buttons&#8221; title_text=&#8221;Navigator preview of Open Tasks with the Load and Transform Data buttons&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>7.<\/strong> Excel automatically launches the Power Query Editor, which can help you automate future loading and transformation of data.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-power-query-editor.webp&#8221; alt=&#8221;Excel connections \u2014 Power Query Editor with the Open Projects query and Query Settings&#8221; title_text=&#8221;Power Query Editor with the Open Projects query and Query Settings&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>8.<\/strong> Once you finish making the changes, click \u201cClose &amp; Load\u201d to continue setting up your connection.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-close-and-load.webp&#8221; alt=&#8221;Excel connections \u2014 Close and Load menu open in the Power Query Editor&#8221; title_text=&#8221;Close and Load menu open in the Power Query Editor&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>9.<\/strong> In the &#8220;Import Data&#8221; box, the first four options will allow you to view the data in your workbook as a &#8220;Table&#8221;, &#8220;<a href=\"https:\/\/www.sheetgo.com\/blog\/excel-features\/pivot-table-in-excel\/\">PivotTable Report<\/a>&#8220;, \u201cPivotChart\u201d, or \u201cOnly Create Connection\u201d. The following two options relate to where the data will be imported, the \u201cExisting worksheet\u201d or a \u201cNew worksheet\u201d, set by default.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-import-data-options.webp&#8221; alt=&#8221;Excel connections \u2014 Import Data dialog with Table, PivotTable Report, PivotChart and Only Create Connection&#8221; title_text=&#8221;Import Data dialog with Table, PivotTable Report, PivotChart and Only Create Connection&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Note that you can change this further on by going to File &gt; Properties.<\/p>\n<p><strong>10.<\/strong> If you select \u201cOnly Create Connection\u201d, you establish the connection to the Access Database without displaying the data in your workbook. Click \u201cOK\u201d to finish.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-only-create-connection.webp&#8221; alt=&#8221;Excel connections \u2014 Only Create Connection selected in the Import Data dialog&#8221; title_text=&#8221;Only Create Connection selected in the Import Data dialog&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>11.<\/strong> You should now be able to see the \u201cQueries and Connections\u201d right-side pane, which provides a breakdown of your newly created external data connection.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-queries-and-connections-pane.webp&#8221; alt=&#8221;Excel connections \u2014 Queries and Connections pane listing four connection-only queries&#8221; title_text=&#8221;Queries and Connections pane listing four connection-only queries&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Once the connection is established, you can easily change the data source at any time.<\/p>\n<h3>How to change the data source in Excel?<\/h3>\n<p>There are many reasons why you may need to change the data source. The most common is that the original data has been transferred to another database. This is how you can quickly change the data source in Excel.<\/p>\n<p><strong>1.<\/strong> Open the Excel workbook that contains the external connection. Go to Data &gt; Queries &amp; Connections. Double-click on any of the queries listed to the right in the \u201cQueries &amp; Connections\u201d pane.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-query-details-open-projects.webp&#8221; alt=&#8221;Excel connection \u2014 Open Projects query details from the Queries and Connections pane&#8221; title_text=&#8221;Open Projects query details from the Queries and Connections pane&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> In the \u201cPower Query Editor\u201d, click on the \u201cData source settings\u201d button to the right.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-data-source-settings-button.webp&#8221; alt=&#8221;Excel connections \u2014 Data source settings button in the Power Query Editor ribbon&#8221; title_text=&#8221;Data source settings button in the Power Query Editor ribbon&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Click on the data source file path and then press the \u201cChange Source\u2026\u201d button, right below.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-change-source.webp&#8221; alt=&#8221;Excel connections \u2014 Data source settings dialog with the Access file path and Change Source button&#8221; title_text=&#8221;Data source settings dialog with the Access file path and Change Source button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> Click \u201cBrowse\u201d to launch \u201cFile Explorer\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-change-source-browse.webp&#8221; alt=&#8221;Excel connections \u2014 Microsoft Access database dialog with the file path and Browse button&#8221; title_text=&#8221;Microsoft Access database dialog with the file path and Browse button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> Choose the new data source and click \u201cOpen\u201d to finish.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-select-new-data-source.webp&#8221; alt=&#8221;Excel connections \u2014 File Explorer window to choose the new Access database file&#8221; title_text=&#8221;File Explorer window to choose the new Access database file&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now you have successfully changed your data source. Excel also allows you to remove external data connections just as easily.<\/p>\n<h3>How to remove external data connections in Excel?<\/h3>\n<p><strong>1.<\/strong> Go to Data &gt; Queries &amp; Connections. Select the connection you want to remove, or press Shift + Down Arrow to select multiple queries.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-select-queries-to-remove.webp&#8221; alt=&#8221;Excel connections \u2014 several queries selected in the Queries and Connections pane&#8221; title_text=&#8221;Several queries selected in the Queries and Connections pane&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> Right-click on the selected queries and click on \u201cDelete\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-delete-query.webp&#8221; alt=&#8221;Excel connections \u2014 right-click menu on the selected queries with the Delete option&#8221; title_text=&#8221;Right-click menu on the selected queries with the Delete option&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Click on \u201cDelete\u201d to confirm that you want to remove the selected queries.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-confirm-query-deletion.webp&#8221; alt=&#8221;Excel connections \u2014 Delete Queries confirmation dialog&#8221; title_text=&#8221;Delete Queries confirmation dialog&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>4.<\/strong> The \u201cQueries &amp; Connections\u201d pane should now appear empty.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-query-pane-empty.webp&#8221; alt=&#8221;Excel connections \u2014 Queries and Connections pane showing 0 queries&#8221; title_text=&#8221;Queries and Connections pane showing 0 queries&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>5.<\/strong> To reverse this process quickly, press Ctrl + Z as many times as needed to reestablish all connections. This might prompt Excel to warn you with the following security warning message \u201cExternal data connections have been disabled\u201d. Click on \u201cEnable Content\u201d to enable the external connections once again.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-security-warning-enable-content.webp&#8221; alt=&#8221;Excel data connections \u2014 security warning bar with the Enable Content button&#8221; title_text=&#8221;Security warning bar with the Enable Content button&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>6.<\/strong> Click \u201cYes\u201d to make the file a trusted document.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-trusted-document.webp&#8221; alt=&#8221;Excel connections \u2014 Security Warning asking to make the file a trusted document&#8221; title_text=&#8221;Security Warning asking to make the file a trusted document&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Now that your external connection is established, you can choose to refresh it manually or automatically.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;how-to-refresh-external-data-connections&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>How to refresh external data connections in Excel?<\/h2>\n<p>There are two ways to refresh and update your external connection in Excel. Let\u2019s see how you can do so manually with one single click.<\/p>\n<h3>How to refresh external data connections in Excel manually?<\/h3>\n<p><strong>1.<\/strong> Go to Data &gt; Refresh All.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-refresh-all.webp&#8221; alt=&#8221;Excel connections \u2014 Refresh All menu open on the Data tab&#8221; title_text=&#8221;Refresh All menu open on the Data tab&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>It\u2019s that easy! This will refresh all connected data. To select the data range to refresh, you can do so by right-clicking on the queries, listed in the \u201cQueries &amp; Connections\u201d pane. Now, let\u2019s see how to set up automatic updates at specified time intervals in Excel.<\/p>\n<h3>How to refresh external data connections in Excel automatically?<\/h3>\n<p><strong>1.<\/strong> In the \u201cQueries &amp; Connections\u201d pane, select the \u201cConnections\u201d tab. Right-click on the connection and select \u201cProperties\u201d.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-connection-properties.webp&#8221; alt=&#8221;Excel connections \u2014 Connections tab with the right-click menu showing Properties&#8221; title_text=&#8221;Connections tab with the right-click menu showing Properties&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>2.<\/strong> In the \u201cQuery Properties\u201d window, the \u201cEnable background refresh\u201d should be enabled by default if the connection type is an \u201cOnly Create Connection\u201d. This makes it possible for the system to carry on working without having to wait for the query to refresh.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-enable-background-refresh.webp&#8221; alt=&#8221;Excel connections \u2014 Query Properties window with Enable background refresh checked&#8221; title_text=&#8221;Query Properties window with Enable background refresh checked&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p><strong>3.<\/strong> Enable the \u201cRefresh every\u201d option to set the frequency of data updates. You can set it as low as 1 minute. As you have also enabled background refresh, it shouldn\u2019t slow down the functioning of Excel. Click \u201cOK\u201d to finish.<\/p>\n<p>[\/et_pb_text][et_pb_image src=&#8221;https:\/\/static.sheetgo.com\/wp-content\/uploads\/2026\/10\/excel-connections-refresh-interval.webp&#8221; alt=&#8221;Excel connections \u2014 Query Properties with Refresh every 1 minutes enabled&#8221; title_text=&#8221;Query Properties with Refresh every 1 minutes enabled&#8221; align=&#8221;center&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; width=&#8221;100%&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;][\/et_pb_image][et_pb_text _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<p>Although creating and customizing external connections in Excel is straightforward, it will depend on the data source properties and data type. If you want to simplify the process of managing and controlling all data inputs to your spreadsheet, <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered data automation platform, might be the best alternative solution. You can quickly <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/bigquery-to-excel\/\">connect BigQuery to Excel<\/a> and link your spreadsheets (Excel, Google Sheets, CSV\/TSV), automate data transfers, and monitor and manage your workflows from the web app.<\/p>\n<p>[\/et_pb_text][et_pb_text module_id=&#8221;conclusion&#8221; _builder_version=&#8221;4.22.2&#8243; _module_preset=&#8221;default&#8221; global_colors_info=&#8221;{}&#8221; theme_builder_area=&#8221;post_content&#8221;]<\/p>\n<h2>Conclusion<\/h2>\n<p>Understanding how to use <a href=\"https:\/\/www.sheetgo.com\/blog\/data-science\/database-vs-spreadsheet\/\">databases<\/a> is essential for anyone who uses Excel to store and manage information regularly. Occasionally, the size and nature of this data will require external storage, whether it\u2019s on a Microsoft server, such as Access or SQL Databases, or your company webpage.<\/p>\n<p>After reading this article, the concept of external connections in Excel and how to use them should be clearer. You should now feel ready to create, change, update, and remove external data connections using the \u201cQueries and Connections\u201d feature in Excel. In case you need to transform data before importing, the Power Query Editor helps you quickly transform the data before loading it from an external source.<\/p>\n<p>To move data between sheets inside one workbook, see how to <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/transfer-data-in-excel\/\">transfer data from one sheet to another in Excel<\/a>. To combine several workbooks into one, you can <a href=\"https:\/\/www.sheetgo.com\/blog\/how-to-solve-with-sheetgo\/consolidate-excel-files-automatically\/\">consolidate Excel files automatically<\/a>.<\/p>\n<p>Finally, you also know about <a href=\"https:\/\/www.sheetgo.com\/automations\/\">Sheetgo<\/a>, an AI-powered alternative that allows you to quickly connect your files and your data in BigQuery, manipulate and transfer the data, and automate entire processes through custom workflows.<\/p>\n<p><a href=\"https:\/\/www.sheetgo.com\/automations\/\">Try Sheetgo Automations<\/a> for free and connect your data across multiple formats and locations.<\/p>\n<p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Depois de conectar seu arquivo do Excel a uma fonte de dados externa, basta atualizar para ter os dados mais recentes. Veja como usar as conex\u00f5es do Excel.<\/p>","protected":false},"author":2,"featured_media":263838,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"","_et_gb_content_width":"","footnotes":""},"categories":[51],"tags":[],"class_list":["post-263811","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-features"],"acf":[],"permalink_manager":null,"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/263811","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/comments?post=263811"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/posts\/263811\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media\/263838"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/media?parent=263811"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/categories?post=263811"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/pt\/wp-json\/wp\/v2\/tags?post=263811"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}