Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Can I get back to my original Data
I have a pivot table but have lost my original data. What can I do to see the data in the original format (i.e. before I put it into a pivot table) Thanks -- Markl ------------------------------------------------------------------------ Markl's Profile: http://www.excelforum.com/member.php...o&userid=13482 View this thread: http://www.excelforum.com/showthread...hreadid=517291 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Can I get back to my original Data
You could make sure that all page fields are displayed as all, no fields are hidden, make sure you have a Grand Total at the bottom of your pivot table and simply double click on this total, your original data should be displayed. There are two exceptions to this 1) If you have the option Save data with table unchecked you won't be able to drill down on the data or 2) The total number of rows of data exceeds 65,536 (the maximum rows of data in a sheet -- Gary Brown ------------------------------------------------------------------------ Gary Brown's Profile: http://www.excelforum.com/member.php...o&userid=17084 View this thread: http://www.excelforum.com/showthread...hreadid=517291 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Pivot Tables - Can I get back to my original Data
You are a star Thanks -- Markl ------------------------------------------------------------------------ Markl's Profile: http://www.excelforum.com/member.php...o&userid=13482 View this thread: http://www.excelforum.com/showthread...hreadid=517291 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Source Data in Pivot Tables | Excel Worksheet Functions | |||
Pivot Tables filtering data | Excel Discussion (Misc queries) | |||
Top 10 data sort in Pivot Tables | Excel Discussion (Misc queries) | |||
Pivot table, dynamic data formula | Excel Discussion (Misc queries) | |||
Pivot Tables multiple data fields | Excel Worksheet Functions |