Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 2316
  • Last Modified:

Turn off "Autofit column widths on update" as the default for Pivot Tables Excel 2010

I would really like to make the Pivot Table check box for "Autofit column widths on update" in Excel 2010 be unchecked as the default.  It is annoying to have to go in and shut it off for every Pivot Table I create.  I am hoping someone knows a regedit to make this happen.  Thanks!
0
pmpatane
Asked:
pmpatane
1 Solution
 
Rgonzo1971Commented:
Hi,

Since HasAutoFormat is a property of the pivottable, I doubt it will be possible to make it as default
Sub Macro1()
'
For Each pvt In ActiveSheet.PivotTables
    pvt.HasAutoFormat = False
Next
End Sub

Open in new window

Regards
0
 
pmpataneAuthor Commented:
Thanks! Wish there had been a way
0

Featured Post

Ask an Anonymous Question!

Don't feel intimidated by what you don't know. Ask your question anonymously. It's easy! Learn more and upgrade.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now