ExcelBanter - Pivot Tables

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Pivot Tables (https://www.excelbanter.com/excel-discussion-misc-queries/136132-pivot-tables.html)

HR Person

Pivot Tables

Every time I refresh my pivot table it changes the width of my columns. How
do I remedy this?

Debra Dalgleish

Pivot Tables

Right click on a cell in the pivot table
Choose Table Options
Remove the check mark from Auto Format table
Click OK

HR Person wrote:
Every time I refresh my pivot table it changes the width of my columns. How
do I remedy this?

--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html

All times are GMT +1. The time now is 11:42 PM.