Run the pivot report and click export Export button on the toolbar. The pivot table will automatically be exported and opened in Excel.

If a Security Warning appears (Data connections have been disabled):
  1. Click Options
  2. Select Enable this content
  3. Click OK
  4. A warning appears similar to The cube file cannot be opened for writing
  5. Click OK
  6. Select the drop down table in cell B3
  7. Click OK