Value Table Settings - Pivot Table

[GWB2010]

Is it possible using Excel 2007, to change the Value Table Settings in multiple columns at one time. I can change one column at a time but want "none" to apply to multiple columns. A kind of "formula Painter" would be ideal.

Thanks