Create, edit, and manage connections to external data
You can use Microsoft Office Excel to create and edit connections to external data sources that are stored in a workbook or in a connection file. By using the Workbook Connections dialog box, you can …
Connection properties - Microsoft Support
Use the Connection Properties dialog box to control various settings for connections to external data sources, and to use, reuse, or switch connection files. This dialog box is often titled Query Properties …
Connect to (Import) external data - Microsoft Support
Connections to external data may be disabled on your computer. To connect to data when you open a workbook, you must enable data connections by using the Trust Center bar, or by putting the …
How to correct a #CONNECT! error - Microsoft Support
A #CONNECT error occurs when a formula can't connect to a required resource. See the following: General
Share external data by using an ODC file (Power Query) - Microsoft …
A great way to share data between Excel users is to use an Office Data Connection (ODC) file. They are designed to be portable and easy to update. We recommend the following approach to sharing …
Find out which data sources are used in a workbook data model
In Excel, click Data > Connections. Select the connection used to populate the table in your model. Click Properties > Definition to view the connection string. Need more help? You can always ask an expert …
Create a PivotTable with an external data source
On page 3, enter the connection file you want to create. To create a new connection to an Access database and import data into Excel as a table or PivotTable, do the following: Click Data > From …
Introduction to data connections - Microsoft Support
A data connection that can get data from or submit data to a Web service is just like a query data connection and a submit data connection combined into a single data connection.
Manage queries (Power Query) - Microsoft Support
The role of the connection information is to maintain data source information and to refresh the data according to refresh settings, such as the frequency. Not all queries may be loaded to a worksheet.
Import data from data sources (Power Query) - Microsoft Support
Use Power Query in Excel to import data into Excel from a wide variety of popular data sources, including CSV, XML, JSON, PDF, SharePoint, SQL, and more.