To save pivot table data to a new spreadsheets:

Right click on the tab for the pivot table. Select Move or Copy

Select New Book

Check “Create a Copy"

Click on OK

The pivot table data is now in a new sheet – you can save it as any name. Note – this pivot table is no longer tied to the original data, so it cannot be refreshed.