Please allow functionality to turn pivot table to basic spreadsheet.
It would be very flexible to be able to deconstruct pivot table into basic worksheet. This should break the connection and all pivot table propertiies. Of course it would be irreversible.

2 comments
-
Anonymous commented
SOLUTION:
double-clicking the grand-total value the pivot table created a new sheet with all the details that the grand-total was based uponThanks.
Thant's what I was looking for but couldn't find solution/steps anywhere.Many thanks.
-
Anonymous commented
If you double-click the grand-total value the pivot table will create a new sheet with all the details that the grand-total was based upon. Isn't that the "basic worksheet" that you want to achieve?