If you are getting the Data source reference is not valid while trying to create a pivot table in Microsoft Excel, see this post for the fix.

3. Convert to formulas. Finally, position your cursor in the PivotTable you want to convert, and from the PivotTable Tools menu, select Analyze, OLAP Tools, Convert to Formulas, as pictured below.

Q. What new PivotTable features, if any, have been added to Excel 2016? A. Microsoft has made several improvements to Excel 2016’s PivotTables. Among them are: 1. Automatic relationship detection: In ...

This default PivotTable displays subtotals for each region and a grand total for all regions. To create this PivotTable, click anywhere inside the data source Excel Table and then do the following: ...