Excel 2007 pivot table formats that work with 2003

  • Thread starter Thread starter Steven
  • Start date Start date
S

Steven

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.
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

excel 2007 pivot table: how to paste special formats? 1
Pivot Table Formats 2
Save Pivot Table Format in 2007 2
Pivot Table Format Preservation 1
Excel 2003 Pivot Table in Excel 2007 3
Excel 2003 Pivot Formatting 2
Pivot table Average with [h]:mm format 5
Pivot table wizards 2

Back
Top