Customizing Excel 2007 pivot tables

[sanmos]

Hi,

I created a pivot table and wanted to format using the styles available. I
first selected that both the rows and columns are banded (row headers and
column headers are checked as well) and then selected the design. But when I
pick a style I do not get the banded rows or style. The one that I had
selected is Pivot Style Medium 6. It worked in one of my files but not in any
of the other seperate files.

Can someone please let me know why.

thanks