column width

[Ben]

Hi all,

here's my dilemma:
I have a worksheets that has some dollar amount spend on consultants and
the month in which the charges were incurred. I set up a pivot table in
which I put the month field in the Page area and the dollar amounts inthe
data area of the pivot table. On the columns area, I put the various
consultant names, some of long names, so what I did was have the cells wrap
around.

After the pivot table is created, a drop is created by the pivot tabel
wizard which list all of the months, so that I can select a particular month
and see only that month's expense.
But happens is when I changed the month in the drop down box for the very
first time, the columns in that contains the name of the consultants (that
is the column area of the pivot table) expands, and looses the wrap text
feature, and then I have to re-adjust the columns again, but if I change to
a different month, the columns would expand again. It's really annoying. I
tried the enable selection option and it does not work.

Please share with me any suggestion you may have, so I can remedy this.
Thanks so much.

Ben