Uncheck AutoFormat (Pivot Tables)

  • Thread starter Thread starter Hans Knudsen
  • Start date Start date
H

Hans Knudsen

I have a workbook (for training purposes) with many different pivot tables.
I want to uncheck AutoFormat table under Table Options
for each 'Refresh Data'.

Some help on the necessary code for that?

Regards
Hans Knudsen
 
Dim ws As Worksheet
Dim pt As PivotTable

For Each ws In ActiveWorkbook.Worksheets
For Each pt In ws.PivotTables
pt.HasAutoFormat = False
Next pt
Next ws
 

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

Unable to Group in Pivot Table 1
Pivot Table Question 2
refresh multiple pivot tables in workbook 2
Excel VBA For excel 0
formatting pivot table report (borders automatically showing)... 3
Code to Refresh inbound data sheets, then Refresh Pivot Tables 3
Pivot Tables - refresh from Userform command button 2
Pivot table multiple filters 2

Back
Top