View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Roger Govier Roger Govier is offline
external usenet poster
 
Posts: 2,886
Default Locking Column Width when changing Data in a Pivot Table

Hi

Right click on PTTableOptionsuntick Autoformat tabletick Preserve
Formatting

--
Regards

Roger Govier


"pepperds" wrote in message
...
I have a Pivot Table, with 2 items in Page, 2 items in Column, and 17
items
in Data. I principally change the values in Page, and when I do the
column
width always changes, either it increases or decreases - how can I
permanently lock this so that I dont have to adjust this manually
every time.

Many thanks in advance
DP