| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Filter lines containing pivot table and non pivot table data | Excel Worksheet Functions | |||
| Pivot Table Data Adding contents of two pivot tables and param que | Excel Discussion (Misc queries) | |||
| Pivot Table - Use Other Pivot Table as Data Source | Excel Discussion (Misc queries) | |||
| How do I sort pivot table data outside a pivot table | Excel Worksheet Functions | |||
| Pivot Table Reversing | Excel Discussion (Misc queries) | |||
Linear Mode
