Pivot Table is reversing data
 

I've used the "double click" on the grand totals to display the underlying
data of a pivot table frequently. I am using Excel 11.0 (2003). Lately
whenever I do this two strange and annoying things happen: 1. The data
structure is reveresed i.e. if my database is set up as "Name", "Age", "Sex"
fields, the data ends up in a new sheet listing "Sex", "Age", "Name". 2.When
I double click on totals, my sheet tabs which are normally on the lower left
of the screen show up on the lower right side, and the horizontal scroll bar
also switches from the lower right to the lower left.

Thanks for any ideas.

Mike

Pivot Table is reversing data
 

Tools | Options - International (uncheck View Current Sheet Right to Left)
--
HTH...

Jim Thomlinson


"mike lewis in texas" wrote:

I've used the "double click" on the grand totals to display the underlying
data of a pivot table frequently. I am using Excel 11.0 (2003). Lately
whenever I do this two strange and annoying things happen: 1. The data
structure is reveresed i.e. if my database is set up as "Name", "Age", "Sex"
fields, the data ends up in a new sheet listing "Sex", "Age", "Name". 2.When
I double click on totals, my sheet tabs which are normally on the lower left
of the screen show up on the lower right side, and the horizontal scroll bar
also switches from the lower right to the lower left.

Thanks for any ideas.

Mike

Pivot Table is reversing data
 

Thanks, I would have spent a long time finding this.

Mike


"Jim Thomlinson" wrote:

Tools | Options - International (uncheck View Current Sheet Right to Left)
--
HTH...

Jim Thomlinson


"mike lewis in texas" wrote:

I've used the "double click" on the grand totals to display the underlying
data of a pivot table frequently. I am using Excel 11.0 (2003). Lately
whenever I do this two strange and annoying things happen: 1. The data
structure is reveresed i.e. if my database is set up as "Name", "Age", "Sex"
fields, the data ends up in a new sheet listing "Sex", "Age", "Name". 2.When
I double click on totals, my sheet tabs which are normally on the lower left
of the screen show up on the lower right side, and the horizontal scroll bar
also switches from the lower right to the lower left.

Thanks for any ideas.

Mike