Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Convert Pivot table back to Data Table | Excel Discussion (Misc queries) | |||
Pivot table: hyperlink back to source data | Excel Discussion (Misc queries) | |||
Convert Pivot Table to Normal Data table | Excel Discussion (Misc queries) | |||
Vlookups in a Pivot table brining back OFFSET Data | Excel Worksheet Functions | |||
Transforming pivot table back to the source table | Excel Worksheet Functions |