Was this page helpful?
Additional feedback?
1500 characters remaining
Export (0) Print
Expand All

Select an Existing Connection

Looking for help with Power Pivot in Excel 2013? Go to Power Pivot Help on Office.com.

This page of the Table Import Wizard enables you to choose an existing data source connection to use. To access the wizard from the PowerPivot window, on the Home tab, in the Get External Data group, click the type of data source from which you want to import tables. For more information about supported data sources and providers, see Data Sources Supported in PowerPivot Workbooks.


Select one of the following values to display a category of data source connections in the Select a data source connection box.



PowerPivot Connections

Connections in the PowerPivot workbook.

Local Connections

Office Data Connection (.odc) files stored on the local computer.

Workbook Connections

Office Data Connection (.odc) files stored in the PowerPivot workbook.

Select a Connection

Select the data source connection to use.

Browse for More

Select an .odc file that is stored on the local machine.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

© 2015 Microsoft