Fill Row in Pivot without changing the order of the columns
 

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.

Fill Row in Pivot without changing the order of the columns
 

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

Fill Row in Pivot without changing the order of the columns
 

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

Fill Row in Pivot without changing the order of the columns
 

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