Typically, nonnumeric fields are added to the Rows area, numeric fields are added to the Values area, and date and time fields are added to the Columns area. In the field list section, check the box next to a field name to place the field in a default area of the areas section of the Field List. To place the PivotTable in the active worksheet, choose Existing Worksheet, and then in the Location box, enter the cell where you want the PivotTable to start.Įxcel adds an empty PivotTable and shows the Field List so that you can show the fields you want and rearrange them to create your own layout. To place the PivotTable in a new worksheet starting at cell A1, choose New Worksheet. Under Choose where you want the PivotTable report to be placed, pick a location. In the list of connections, select the connection you want, and then click Open.

To reuse or share an existing connection, use a connection from Connections in this Workbook. On the Connections tab, in the Show box, keep All Connections selected, or pick the connection category that has the data source you want to connect to. In the Create PivotTable dialog box, click From External Data Source. Here’s how to create a PivotTable by using an existing external data connection: In that case, you’ll connect to the external data source, and then create a PivotTable to summarize, analyze, explore, and present that data. But sometimes it’s hard to know where to start, especially when you have a lot of data that is stored outside of Excel, like in a Microsoft Access or Microsoft SQL Server database, or in an Online Analytical Processing (OLAP) cube file.

Lessīeing able to analyze all the data can help you make better business decisions. Excel for Microsoft 365 Excel 2021 Excel 2019 Excel 2016 Excel 2013 Excel 2010 Excel 2007 More.

Excel 2013 create pivot table