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