Pivot table 2003 - 2007

[vasim]

Hi,


In pivot table 2003, while preparing the layout there's a column/field as "PAGE", the data inputted in this field have options when double clicked to select/unselect values to be showed/displayed in pivot (Report filter in 2007). I am not able to find this feature in 2007 (of deselecting items to be visible in the dropdown.) Any help.

 

[vijaySharma]

In excel 2007, right click inside your Pivot table and then click on PivotTable Options...


Go to the Display Tab


make a check mark on


Classic PivotTable layout (enables dragging of fields in the grid)


Try this out and let us know if this is what you wanted.


~VijaySharma

 

[vasim]

Thanks Vijay but that doesnt give me a solution, i believe in 2007 this option would have been disabled.

 

[VaraK]

Hello Indian,


Page field in xl 2003 is same as Report filter in xl 2007. Hope this helps.