convert Pivot table back to Data table
 

I have a pivot but i don't have the data source, how to convert the pivot
into a normal data table again?

convert Pivot table back to Data table
 

Hi

I presume you will only be able to do this if you have Drilldown
enabled and the pivot cache has not been cleared, in which case you
could access the underlying data by double-clicking on the Grand
Total.

Richard


On 21 Mar, 08:58, Samaa wrote:
I have a pivot but i don't have the data source, how to convert the pivot
into a normal data table again?

convert Pivot table back to Data table
 

Yes i can access the information but for that record only, but how to do so
for the entire data in the table in one time as i have around 3000 rows in
the pivot

"RichardSchollar" wrote:

Hi

I presume you will only be able to do this if you have Drilldown
enabled and the pivot cache has not been cleared, in which case you
could access the underlying data by double-clicking on the Grand
Total.

Richard


On 21 Mar, 08:58, Samaa wrote:
I have a pivot but i don't have the data source, how to convert the pivot
into a normal data table again?