Pivot Table column sizing

S

shaunap

I searched for prior issues about column sizing in pivot tables and came
across one which stated that the user should uncheck the AutoFormat Table and
keep the Preserve Formatting checked in the table options. I did as
suggested and wound up with the pivot table saving the column sizing I wanted
but "erased" the other formatting implemented by the AutoFormat template I
picked (as in colors and bolding). Is there any way I can use the AutoFormat
templates and "modify" somewhat without losing my adjustments everytime I
refresh?

Thank you
 

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

Dealing with a Pivot Table (when I don't want to) 0
Pivot Table Column Widths will not stay fixed... 0
Additional columns for Pivot table 0
column width in autoformatted pivot table 5
Maintain format of pivot after refresh 0
Format PivotTable 1
Preserve Formatting for Pivot table cross 'Refresh Data !' 0
Pivot table put multiple "Values" in one row but I want them in one column. 0

Top