Pivot Table - How do I change the default for Autofit Column width upon refresh?

[HuskerMann]

Hello! I would like to have the default setting for the Autofit column widths in the PivotTable Options menu to ALWAYS be off (meaning the check mark is not in the box by default). How do I do this? Many thanks for your help with this!

 

[VoG]

Link to cross post http://www.mrexcel.com/forum/showthread.php?t=636440

 

[HuskerMann]

Hello Peter - thank you for connecting my two posts. I was unsure how to do that. I realized this morning that my first post was under PowerPivot which I actually don't have so I wanted to put it up under the more general question section. Sadly I have not received any help on how to get the check mark to default as off. Do you have any thoughts on this or can you point me in the right direction? Thanks.