PivotTable: how to align row data to the left?

[blackpuppy]

After dropping a field into the Row Fields area, the row data will be
aligned in the center. But since it is text, I want to align it to the
left. How to do that? I guess it's no use just changing the cell
formatting.

Thanks!

[Tom Ogilvy]

format the cells.

--
Regards,
Tom Ogilvy


"blackpuppy" wrote:

> After dropping a field into the Row Fields area, the row data will be
> aligned in the center. But since it is text, I want to align it to the
> left. How to do that? I guess it's no use just changing the cell
> formatting.
>
> Thanks!
>
>

[blackpuppy]

I tried this out. Once I refresh the data using menu Data --> Refresh
Data, the formatting will be gone.

Sorry, I didn't state my scenario completely. I am using a .NET
WinForm app to control the Excel programmtically. The data will be
generated as XML and imported into Excel. So every time, I need to
refresh the data.

Any other ideas?

Thanks!