Show All

Change the external connection information for a PivotTable list

1. Click the PivotTable list to select it.
2. Click inside the PivotTable list to activate it.
3. Right-click the PivotTable list, click Commands and Options, and then click the Data Source tab.
4. Click Connection, and then click Edit.
5. Locate the data source you want to use in the Look in box, and double-click it in the list. If the data source you want to use is not available, click New Source and follow the instructions in the Data Connection Wizard to create a new connection file for your data.

   Security Note Under some circumstances, a user can view the information used to connect to an external data source. This may represent a security risk. For more information, see About making connections to external data sources more secure.

6. Under Use Data from, do one of the following:
   • To select a different table or query, click Data member, table, view, or cube name, and then select the record source you want from the list.
   • To change the command text, click Command text or SQL, and then enter the query to select the data. For information about the query syntax, see the documentation for the external data source.

Notes

• To use data from a Microsoft Excel worksheet, you have to publish the data to a Web page from Excel. If you want to turn the Web page into a data access page, open it in Microsoft Access, and then add controls that are bound to Access or Microsoft SQL Server database data.
• When you have a Microsoft Office Web Component bound to an external data source on the same data access page with controls bound to an Access or SQL Server database, the component control uses a different data source control than the rest of the page.