How to manage All External Data Source Connections in MS eXcel

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.