Every time I refresh the data, my column width formatting goes back to unformatted state...
Can I somehow lock my columns on my pivot table so that when I refresh data, the columns remain the way I want?
Thanks!
Every time I refresh the data, my column width formatting goes back to unformatted state...
Can I somehow lock my columns on my pivot table so that when I refresh data, the columns remain the way I want?
Thanks!
Please read forum rules below. Duplicate posts are not permitted. I'e deleted your other post for you this time
This link may help
http://www.contextures.com/xlfaqPivot.html#FormatLost
VBA Noob
_________________________________________
Credo Elvem ipsum etian vivere
_________________________________________
A message for cross posters
Please remember to wrap code.
Forum Rules
Please add to your signature if you found this link helpful. Excel links !!!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks