disable autosorting in Pivot Table Excel 2000
 

Hi there,

i recently was asked by a user she can't move the row in a Pivot Table, and
i fingered out it looked like to be the autosorting fuction. but i can't
finger out how to disable it. could somebody help? we are using excel 2000.

thanks for any information.

disable autosorting in Pivot Table Excel 2000
 

Double-click on the field button for the item she wants to move.
Click the Advanced button.
Under AutoSort, select Manual.

Fred wrote:
Hi there,

i recently was asked by a user she can't move the row in a Pivot Table, and
i fingered out it looked like to be the autosorting fuction. but i can't
finger out how to disable it. could somebody help? we are using excel 2000.

thanks for any information.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

disable autosorting in Pivot Table Excel 2000
 

Thanks Debra,

That's what I did, and I double checked it, it was on Manual, however, I
still can't move the items; all the order commands were greyed. Know why?

Sincerely,

"Debra Dalgleish" wrote:

Double-click on the field button for the item she wants to move.
Click the Advanced button.
Under AutoSort, select Manual.

Fred wrote:
Hi there,

i recently was asked by a user she can't move the row in a Pivot Table, and
i fingered out it looked like to be the autosorting fuction. but i can't
finger out how to disable it. could somebody help? we are using excel 2000.

thanks for any information.



--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html