You can create a PivotTable in Excel from an external data source, a table in your worksheet, or a pre-built data model. To ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.

All details in this article are correct as of October 29, 2025. Accessibility to some of the latest Excel features depends on ...