LinkBack URL
About LinkBacks
Hello, I have a problem. Every time I refresh the pivot table, the width of the columns always change. I have it set up as 13.5 but after refresh certain columns go to 6 or 7.
Hello, I have a problem. Every time I refresh the pivot table, the width of the columns always change. I have it set up as 13.5 but after refresh certain columns go to 6 or 7.
Column width depend on your text data width.
atul
If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.
Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".
You gave me an idea. All I have to do is make some kind of a invisible text that fills the row so it won't ever change again. Basically, it will be locked.Originally Posted by avk
Uncheck the autofit column option under the pivot table options.
Untitled.jpg
Thanks, kersplash.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
Register To Reply
Bookmarks