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 …

Know which environment you're in Power Query is well-integrated into the Excel user interface, especially when you import data, work with connections, and edit Pivot Tables, Excel tables, …

Tip: If you do not see the connection that you want, you can create a connection. Click Browse for More, and then in the Select Data Source dialog box, click New Source to start the Data …

Although Excel can tell you when a relationship is needed, it can't tell you which tables and columns to use, or whether a table relationship is even possible. Try following these steps to …

Create a PivotTable (pivot table) by connecting to an external data source like an Access or SQL Server data base or an Online Analytical Processing (OLAP) cube file.

You can then select the revised connection file, a different connection file, or create a new connection file by clicking New Source, which starts the Data Connection Wizard. Make sure …

If you don't find the connection that you want, you can create a connection by clicking Browse for More to display the Select Data Source dialog box, and then clicking New Source to start the …

You can refer to the contents of cells in another workbook by creating an external reference formula. An external reference (also called a link) is a reference to a cell or range on a …

This article describes the syntax that is necessary to configure an Excel data source as a linked server, as well as the syntax that is necessary to use a distributed query that queries an Excel …

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 …