Can't get Excel column width to be fixed

[djgolds]

I've created a PivotTable and below that I've entered formulas for percentages based on the calculations in the PivotTable. Every time I change my selection in the Pivot table, it reduces the column widths so that it's not wide enough for the calculations I've entered in below. Any suggestions on how to make it stay at a fixed width?

Thanks!

 

[DaleWatson123321]

One would expect that if you "fix" the column widths to a specific width - i.e. by right-clicking on the column letter, choosing "Column Width" and entering a number - then that width should remain fixed.

However, if that doesn't work, here's a VBA example routine that you can use. Of coure modify it to include the specific columns and widths you require.

Sub Set_ColumnWidths()
Columns("A:A&quot.EntireColumn.ColumnWidth = 12
Columns("C:C&quot.EntireColumn.ColumnWidth = 12
Columns("E:E&quot.EntireColumn.ColumnWidth = 12
End Sub

I hope this helps. Please advise as to how you make out.

Regards, ...Dale Watson dwatson@bsi.gov.mb.ca

 

[combo]

To keep column widths unchanged while changing/refreshing, select "Table options..." from pivot table menu and deselect "Autoformat table" on "Pivot table options" displayed dialog.