Excel: Pivot Tables into static tables

To convert a pivot table into a static table:

  1. Select the Pivot Table.

  2. Paste Special (ALT-E-S).

  3. Choose "Values and number formats":