Sign in with Microsoft
Sign in or create an account.
Hello,
Select a different account.
You have multiple accounts
Choose the account you want to sign in with.

If you're working with data that's been added to an Excel data model, then sometimes, you may lose track of which tables and data sources were added to the data model.

Note: Make sure you have enabled the Power Pivot add-in. For more information, see Start the Power Pivot add-in for Excel.

Here are a few easy steps you can follow to determine exactly what data exists in the model:

  1. In Excel, click Power Pivot > Manage to open the Power Pivot window.

  2. View the tabs in the Power Pivot window.

    Each tab contains a table in your model. Columns in each table appear as fields in a PivotTable Field List. Any column that is grayed-out has been hidden from client applications.

    Power Pivot tabbed window

  3. To view the origin of the table, click Table Properties.

    If Table Properties is grayed out and the tab contains a link icon indicating a linked table, the data originates from a sheet in the workbook rather than an external data source.

    For all other types of data, the Edit Table Properties dialog shows the connection name and query used to retrieve the data. Make a note of the connection name, and then use Connection Manager in Excel to determine the network resource and database used in the connection:

    1. In Excel, click Data > Connections.

    2. Select the connection used to populate the table in your model.

    3. Click Properties > Definition to view the connection string.
       

Note: Data models were introduced in Excel 2013. You use them to create PivotTables, PivotCharts, and Power View reports that visualize data from multiple tables. Learn more about data models in Create a Data Model in Excel.

Need more help?

You can always ask an expert in the Excel Tech Community or get support in Communities.

Need more help?

Want more options?

Explore subscription benefits, browse training courses, learn how to secure your device, and more.

Communities help you ask and answer questions, give feedback, and hear from experts with rich knowledge.

Was this information helpful?

What affected your experience?
By pressing submit, your feedback will be used to improve Microsoft products and services. Your IT admin will be able to collect this data. Privacy Statement.

Thank you for your feedback!

×