Excel's PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, ...

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.

The display is separate from the source data and doesn’t change the source data in any way. In Excel, PivotTable refers to the tool that helps you create a pivot table.

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.