View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Fred Smith Fred Smith is offline
external usenet poster
 
Posts: 623
Default Pivot table column widths

I have a pivot table with nice compact column widths, formatted with Table4.

When I choose a specific page field, the all column widths are adjusted to the
size of the field chosen.

If I turn off Autoformat table in Table Options, that stops the columns from
being resized, but it also deletes the table formatting (bold, colors, etc.)

Is there a way to stop the column widths from being resized, but keep the format
of the table?

The table is created in a macro, so if the solution involves VBA, that would be
fine.

--
Regards,
Fred