Pivot Table loses formatting after refresh?

G

genxgeek

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...7YNqAfC6r8dKWDxwiu__5Wzf/MergedCellsPivot.bmp


Any information would be greatly appreciated.

Thanks!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I keep my pivot tables format from changing? 5
Pivot Table refresh 3
Pivot Table Refresh? 1
Formatting of Pivot table 1
Pivot Table Refresh not working properly 1
Pivot table and chart refresh not an option 1
Formatting Pivot Tables 3
Conditional Formatting in a pivot table 2

Top