Home |
Search |
Today's Posts |
#4
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Then I think you're out of luck.
Rajula wrote: Thanks for the response. But its a dynamiz Pivot table which i refresh everyday with data. So copying will not help me. Rajula "Dave Peterson" wrote: Nope. But maybe you could copy the pivottable to a new page and paste special|Values. Then you could do whatever you wanted to that data (it's no longer a pivottable). Debra Dalgleish has some notes that you may want to read: http://www.contextures.com/xlDataEntry02.html Rajula wrote: Is there a way to to fill all the rows in a Pivot table & still keep it as a pivot without changing the order of the columns. Bcos in the pivot that i am using, changing the order of the columns is not helping. -- Dave Peterson -- Dave Peterson |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Pivot tables and dynamic columns | Charts and Charting in Excel | |||
In Excel 2000, How can I change the order in a pivot table? | Charts and Charting in Excel | |||
Pivot tables - inserting columns | Excel Worksheet Functions | |||
Pivot Table Creating New Columns that Subtract Two Existing Columns | Excel Discussion (Misc queries) | |||
combining 3 columns of same info for a pivot table | Excel Worksheet Functions |