D
delecto
I'm currently testing out Office 2007 for my company (we currently use
2003) and I've run into a couple of questions regarding pivot table
formatting.
1. In 2003, when I told a pivot table to "preserve format," it
actually worked. For example, I have a page field in which the text
gets very long. I'd like to have it "taller" and with wrapped text. In
2003, I changed that field to "all", set my formatting, and refreshed
the pivot - worked great, the cell stayed as formatted. In 2007, I
have "Preserve cell formatting on update" checked. I repeat these
steps... and when I change the pivot table ... the row height changes.
Driving me nuts!
2. In 2003, I have pretty a simple conditional format with my pivot
table. Let's say it goes from $a$5:$f$20. Column A is static while b:f
contains the actual data. When I pivot, the conditional formatting
disappears on b:f. It just stays on column A.
Any help or direction would be greatly appreciated!
2003) and I've run into a couple of questions regarding pivot table
formatting.
1. In 2003, when I told a pivot table to "preserve format," it
actually worked. For example, I have a page field in which the text
gets very long. I'd like to have it "taller" and with wrapped text. In
2003, I changed that field to "all", set my formatting, and refreshed
the pivot - worked great, the cell stayed as formatted. In 2007, I
have "Preserve cell formatting on update" checked. I repeat these
steps... and when I change the pivot table ... the row height changes.
Driving me nuts!
2. In 2003, I have pretty a simple conditional format with my pivot
table. Let's say it goes from $a$5:$f$20. Column A is static while b:f
contains the actual data. When I pivot, the conditional formatting
disappears on b:f. It just stays on column A.
Any help or direction would be greatly appreciated!