I have tried everything I can think of in order to get this to work and this
is my last resort.

I do a lot of sales reports and I recently got excel 2007 but the users of
the reports are on excel 2003. I can get everything to work but no matter
what I try I can not format the pivot table to anything else other than the
blank default setting.

If I do apply a format then excel 2003 just opens it without the format.

Now before everyone says to use the design tab please understand that I am
looking for apperance only, I want the header bar to be black and the text
white, that is the kind of formating I am talking about.

Does anyone know how to overcome this?

The pivot table styles won't stick, but you could manually format the
header, and that should be visible in earlier versions of Excel.

Steven wrote:
I have tried everything I can think of in order to get this to work and this
is my last resort.

I do a lot of sales reports and I recently got excel 2007 but the users of
the reports are on excel 2003. I can get everything to work but no matter
what I try I can not format the pivot table to anything else other than the
blank default setting.

If I do apply a format then excel 2003 just opens it without the format.

Now before everyone says to use the design tab please understand that I am
looking for apperance only, I want the header bar to be black and the text
white, that is the kind of formating I am talking about.

Does anyone know how to overcome this?


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html