| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Extracting saved data from pivot table
I have a pivot table with saved data. The original input data is no longer
present. Is there a way that I can extract the original data from the pivot table? |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting saved data from pivot table
If you double-click on the grand total cell, it may extract all the
underlying data to a new worksheet. Marcus Langell wrote: I have a pivot table with saved data. The original input data is no longer present. Is there a way that I can extract the original data from the pivot table? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Extracting saved data from pivot table
Wonderful! Thanks a lot, Debra!
"Debra Dalgleish" wrote: If you double-click on the grand total cell, it may extract all the underlying data to a new worksheet. Marcus Langell wrote: I have a pivot table with saved data. The original input data is no longer present. Is there a way that I can extract the original data from the pivot table? -- Debra Dalgleish Excel FAQ, Tips & Book List http://www.contextures.com/tiptech.html |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| OLAP Pivot table - How to show items with no data ? | Excel Worksheet Functions | |||
| pivot table - New Data | Excel Discussion (Misc queries) | |||
| Help PLEASE! Not sure what answer is: Match? Index? Other? | Excel Worksheet Functions | |||
| Pivot table Data refresh | Excel Worksheet Functions | |||
| pivot table | Excel Discussion (Misc queries) | |||
Hybrid Mode
