Pivot column field orientation

  • Thread starter Thread starter David
  • Start date Start date
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
 
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...
 
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
 
Is Enable Selection turned on? (From the Pivot toolbar, choose
PivotTable>Select, and click on Enable Selection)
 
You must log in or register to reply here.

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

Pivot table field formatting 1
VBA Pivot Table Error 1
Pivot table column help 2
Excel VBA For excel 0
Pivot table format question 3
Pivot table report invalid 0
Pivot Table Filters 2
Pivot tables - new columns 5

Back
Top