I think this would work. I have XL2003.

1. Drag all fields out of the pivot table.

2. Drag one field as a data item (Drop the field where it says "Drop Data
Items Here").

3. You should now have one row and two columns in the pivot table. with the
bottom right cell showing a number. Double click that number.


--
Hope that helps.

Vergel Adriano


"Rishabh" wrote:

Hi,

I have a excel with pivot table but the data source of the pivot table is
some other excel which is not given to me. I need to read the original data
(i.e. unpivoted data) from it. Is there any way... I have no clue about.
Can any one provide me some pointers.

Regards
Rishabh