About a year ago, I had a similar problem that spontaneously fixed itself. This time I don't know if I will be so lucky.

The issue is that for every pivot table in any file running on my machine, I am unable to drag the column or row values to change the sort order - I.e. if the row is Jan/Feb/Mar/etc., I can't drag Jan down to the middle or rearrange them - it will sort by ascending or descending value just fine, but simply won't allow me to rearrange - the 4-way arrow doesn't appear where it should when mousing over the fields. I can drag fields on/off and from/to the column/row/data sum areas, but I simply cannot re-arrange the order of the values (and yes, the Autosort checkbox is set to "manual" in field settings.)

Has anyone seen this bizarre problem and does anyone have a solution, short of re-installing excel or getting a new machine?

Thanks!