How do I find the source of an Excel file?

Question

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.

How do I find external sources in an Excel workbook?

On the Formulas tab, in the Defined Names group, click Name Manager. Check each entry in the list, and look in the Refers To column for external references. External references contain a reference to another workbook, such as [Budget.

What is the source in Excel?

The Excel source extracts data from worksheets or ranges in Microsoft Excel workbooks. For detailed info about connecting to Excel files, and about limitations and known issues for loading data from or to Excel files, see Load data from or to Excel with SQL Server Integration Services (SSIS).

How do I find Data connections in Excel?

Go to Data Tab. Choose Connections, this will open the Workbook Connections dialog. In Workbook Connections dialog box it will list all of your connections. Select the Connection in question and then click in the area below to see where it's used.

How do I find a worksheet reference in Excel?

Open your excel sheet and navigate to the 'Data' tab, select the option “Edit Links”. In the “Edit Links” window all the spreadsheets which are referenced in your excel file will be listed.

Expert · Answer