Stop column width from changing on pivot table....?
 

Hello All,

I have a worksheet where I need a column to be 315 pixels wide all the
time. This column is part of a pivot table. Whenever I change the
page option though (via the pull-down list), the column that needs to
stay at 315 pixels shrinks back in size to something smaller. Any
ideas on how to get it to stay at 315 pixels wide?

TIA,

myk

Stop column width from changing on pivot table....?
 

Myk,

Just uncheck the Autoformat table option, in the Pivot Table Options Page
(Table Option in context menu)...

Best,

RGO

"myk" wrote:

Hello All,

I have a worksheet where I need a column to be 315 pixels wide all the
time. This column is part of a pivot table. Whenever I change the
page option though (via the pull-down list), the column that needs to
stay at 315 pixels shrinks back in size to something smaller. Any
ideas on how to get it to stay at 315 pixels wide?

TIA,

myk

Stop column width from changing on pivot table....?
 

perfect - thank you!

myk