disable autosorting in Pivot Table Excel 2000

F

Fred

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.
 
D

Debra Dalgleish

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

Fred

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,
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top