Create, edit, and manage connections to external data
The Workbook Connections dialog box (Select Data > Connections) helps you manage one or more connections to external data sources in your workbook. Create, edit, refresh, and delete …
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 …
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 …
Manage workbook links - Microsoft Support
Linking to other workbooks is a very common task in Excel, but sometimes you might find yourself with a workbook that has links you can’t find even though Excel tells you they exist.
External data connection disabled - Microsoft Support
When you attempt to open a .IQY, .OQY, .RQY or .DQY file using Excel, you will get an error message stating that the file's data connection has been disabled because it is coming from …
Create a PivotTable with an external data source
On the Connections tab, in the Show box, keep All Connections selected, or pick the connection category that has the data source you want to connect to. To reuse or share an existing …
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 …
Manage external data ranges and their properties
You can change the properties of an external data range to control data that has been imported into a worksheet through a connection to an external data source, such as a database, a Web …
Block or unblock external content in Office documents
Using Microsoft Query, you can connect to external data sources, select data from those external sources, import that data into your worksheet, and refresh the data as needed to keep your …
Introduction to data connections - Microsoft Support
A query data connection gets data from an external data source and stores that data in fields in the main or secondary data source of a form. You can then bind controls to those fields to …