PivotTables are interactive worksheet tables used to summarize and analyze data from existing, and perhaps large, tables. You can choose either to save a pivot table directly in Microsoft Excel or to add one as an object on a form.

You must have Microsoft Excel with Microsoft Query installed on your computer to create a pivot table. For more information, see Microsoft Excel Help.