Show Details of all cells at once

Originally Posted by MarvinP

Hi David,

So you have a bunch of data that you've done a pivot table on. The Pivot is 35 columns and 45 rows. If you double click on a cell in the Pivot Table it will create a new sheet showing all the data that made up that cell's data. When I do this I look at the data and then delete the new sheet and double click on another cell to "showall" for it.

Why do you want to "show all" if you need all of it, when it is already in the data that created the pivot table you started with in the first place??

I need the data in a different format as an input into anither file I have. The pivot table format won't work for me for what I need.