HELP! I want to auto fit columns based "not" on field name length but
on the longest data string within a specific column.

Issue:
I have created a pivot table and am able to succesfully drill down to
the underlying information. However, the drilled down s/s auto fits
the columns based on the field names and not the width of the longest
string within the column. I want to run some code to look at and
adjust all the columns based on the longest string within each column,
*not" the length of the field name. I also don't want to touch the
pivot table data field names. Any thoughts?

Ver. XL2K

TIA,
Liz

did you try selecting the cells in the column in the pivot table below the
field name and doing Format=Column=Autofit Selection

--
Regards,
Tom Ogilvy

"Liz Anderson" wrote in message
om...
HELP! I want to auto fit columns based "not" on field name length but
on the longest data string within a specific column.

Issue:
I have created a pivot table and am able to succesfully drill down to
the underlying information. However, the drilled down s/s auto fits
the columns based on the field names and not the width of the longest
string within the column. I want to run some code to look at and
adjust all the columns based on the longest string within each column,
*not" the length of the field name. I also don't want to touch the
pivot table data field names. Any thoughts?

Ver. XL2K

TIA,
Liz