Pivot column field orientation

D

David

Greetings,
I can change the formatting of a pivot column field to
vertical text orientation. How do I retain this format
after refreshing the table? (goes back to original format
whatever I do up to now)
TIA
David
 
D

Debra Dalgleish

Greetings,
I can change the formatting of a pivot column field to
vertical text orientation. How do I retain this format
after refreshing the table? (goes back to original format
whatever I do up to now)
Click to expand...
 
D

David

Debra,
Thanks for your response. I should have mentioned that I
am running Excel 97. I followed your advice (Pivot
toolbar/Pivot Table/Options/Preserve Formatting ticked)but
the formatting immediately reverts to horizontal and
autofit column widths. Any ideas?
TIA
David
 
D

Debra Dalgleish

Is Enable Selection turned on? (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)
 

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

Excel does not accept text format! 0
When refreshed, some Pivot Table columns retain formatting, some d 0
VBA Pivot Table Error 1
Pivot table report invalid 0
Retain pivot table formatting after refreshing data 0
Word 2016 - Difficulties Learning Style Creation/Application 0
ASK Field Formatting 1
Pivot table field formatting 1

Top