View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Rafael Guerreiro Osorio Rafael Guerreiro Osorio is offline
external usenet poster
 
Posts: 27
Default 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