LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
sansk_23
 
Posts: n/a
Default Convert PivotTable data into a worksheet list

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?
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Export address list data in an Excel worksheet for importing into. ACR/HJG Excel Discussion (Misc queries) 1 April 15th 05 11:43 PM
Get External Data Web Query new worksheet Nina Excel Discussion (Misc queries) 0 April 14th 05 07:08 PM
eliminate data entered to a worksheet that copies to another work. flaguilar Excel Worksheet Functions 2 March 14th 05 05:20 PM
Merging data from an excel worksheet into an excel template pkasler Excel Worksheet Functions 1 March 13th 05 04:36 AM
How to lock a worksheet and enable the PivotTable refresh data opt Saariko Excel Worksheet Functions 3 October 31st 04 03:02 PM


All times are GMT +1. The time now is 05:17 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"