Hi!

This might help:

http://j-walk.com/ss/excel/usertips/tip068.htm

Biff

"sansk_23" wrote in message
...
i wish to convert the data given in a tabular form (as displayed in a pivot
table) to a worksheet list. Or, in simpler words, to reverse the Pivot
Table
action without clicking the undo botton. Like we convert the worksheet
list
to a pivot table, can we convert the pivot table back in the for of a
detailed worsheet listing?