A pivot table in Microsoft Excel reorganizes data quickly into a meaningful report, and it's easy to use!

PivotTable objects are only as good as their underlying data and that can change quickly. If the pivot tables are part of a dashboard, they might not reflect updates at the source level.

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.