Microsoft Excel Questions and Answers

What you could do to stop the pivot table from loosing the column width upon refreshing?

Format loss in pivot table can be stopped simply by changing the pivot table options.  Under the “Pivot Table Options” turn on the “Enable Preserve Formatting” and disable “ Auto Format” option.