WRT formatting a pivot table, I have a merged pivot view. However, when I
refresh the data columns that I had previously formatted as left justified
and indented (item and notes column below) get re-centered. Makes sense since
I have the following Merge Cells and Center checked but I'm wondering how I
can Merge cells and left justify the item and notes columns so that when
refreshed formatting never changes and autoresizes.

This is the current format that I have setup and I would like the cols to
remain left justified and automatically resize (so that text isn't cut off
via the height, partially displayed).

http://6aqawg.bay.livefilestore.com/...CellsPivot.bmp


Any information would be greatly appreciated.

Thanks!