Managing All External Data Source Connections
With a Microsoft Office Excel workbook open, click the Data tab, and then click Connections. You can then view the data sources used in the workbook. If you select one, you can also see where that connection is used by clicking the Properties button. This feature is especially helpful when working with online analytical processing (OLAP) cubes via Excel.