F
Fred Smith
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.
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.