Pivot Tables 2003 to 2007

[ianb]

Hi I have loads of pivot tables that I would like to set to the new design of 2007.


When I try and chnage the design it does not work for me.


Do you have a VBA program that can loacte all pivot tables and chnage the design to a new design so I can work with the new style pivot tables.


Th Design select is not working for me....

 

[Faseeh]

Hi ianb,


Have you tried to upgrade the Excel 2003 file to 2007?? I think that should work.


Faseeh

 

[ianb]

I Did and then.


PIVOT TABLES

HIGHLIGHT ALL

FORMAT CELLS

BACKGROUND COLOUR – NO FILL.


This works.