Right-click on a cell in the pivot table, and choose Table Options
Remove the check mark from AutoFormat table, and click OK

Aaron wrote:
Hello,

I am wondering if there is a way to lock in the current column widths of my
pivot tables so they won't change widths with new data. If not, I assume I
need to have code to change back to old column widths every time my tables
are refreshed? Thanks much,

Aaron


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