View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Hans Knudsen Hans Knudsen is offline
external usenet poster
 
Posts: 36
Default Uncheck AutoFormat (Pivot Tables)

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