Sundance_Kid
Board Regular
- Joined
- Sep 2, 2017
- Messages
- 130
- Office Version
- 365
- Platform
- Windows
Hi, I have a pivot table with multiple columns, most of the columns have numbers in them but a couple of the columns would have text.
When I go to refresh the pivot, depending on the length of text in one of the rows in the column the width of the colum will automatically expand to fit all the text in.
Is there a way to freeze the width of the column without preventing the user from refreshing the file or filtering on it?
Thanks
When I go to refresh the pivot, depending on the length of text in one of the rows in the column the width of the colum will automatically expand to fit all the text in.
Is there a way to freeze the width of the column without preventing the user from refreshing the file or filtering on it?
Thanks