In a blank row above the pivot table add in some text (aaaaa or such)
designed to create the correct column width. It's kinda cheesy but it works...
--
HTH...

Jim Thomlinson


"Iriemon" wrote:

I have a worksheet containing several pivot tables. Is there any way to
"lock" the column widths so that when I refresh the tables the column widths
remain as I have them set?

Thanks

J