Format a pivot table without activating the worksheet

[gruzlor]

Hi all,

I have a workbook in which several tabs are used for calculation and two for the resulting PivotTables.
My ribbon has been modified so that the user can at anytime refresh the calculation and formatting of the whole workbook.

My problem is that I need to select specific part of each Pivottable in order to format it.
Hereafter an example :

Please Login or Register  to view this content.

The problem is related to PivotSelect . I have to select the tabs before formatting them which makes you epileptic

Any advice on how to avoid that?

Cheers.

[gruzlor]

Anybody an idea?

[Izandol]

Do you use Application.Screenupdating = False at the start of your code?

[gruzlor]

Yes I use but it doesn't hide the switching between tabs...

I also tried commenting the code to format the PivotTable once the table was formatted but it gets back to the original style.

Help?

[Izandol]

You should not see tabs switching if you have turned screenupdating off.

[gruzlor]

Indeed. And I found the problem : the PivotTable Field list should not be anchored.
Thanks for your help.