Anonymous
Anonymous Asked in Cars &Transportation · 2 weeks ago

Where is the data source in Excel?

Contents
  1. How do I find the data source in Excel?
  2. How do I find the data source of a table?
On the Ribbon, under the PivotTable Tools tab, click the Analyze tab (in Excel 2010, click the Options tab). In the Data group, click the top section of the Change Data Source command. The Change PivotTable Data Source dialog box opens, and you can see the the source table or range in the Table/Range box. 14 апр. 2022 г.


How do I find the data source in Excel?

Find out which data sources are used in a workbook data model1In Excel, click Data > Connections.2Select the connection used to populate the table in your model.3Click Properties > Definition to view the connection string.

How do I find the data source of a table?

Note: Only a superuser can view data source tables.1Click the Data Mining Runs tab. The Data Mining Runs page appears.2Select the row menu ( )for a run, and then click View Jobs for Run. ... 3Click Sources. ... 4Click the name of the data source table that you want to view. ... 5Perform actions on the table:

Related Questions

Relevance
Write us your question, the answer will be received in 24 hours