
Creator
2019-03-07
11:29 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
property to prevent column width in pivot table to change
Hi,
What property should be checked or unchecked in order to prevent the column width in a pivot table to be changed.
I must have checked (or unchecked) it by accident and I can't set it off anymore.
Thanks
R.W.
681 Views
3 Replies


MVP
2019-03-07
11:39 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If your pivot is in a container the column-width couldn't be changed anymore (AFAIK it's not designed in this way else it's a bug). Further check the options in the object-properties in tab layout.
- Marcus
675 Views

Creator
2019-03-07
12:04 PM
Author
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Marcus,
Thanks for your reply.
AFAIK I didn't put it in a container.
So it's a bug?
R.W.
672 Views


MVP
2019-03-08
02:27 AM
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
If the table isn't in a container I think it's rather not a bug. Did you check the sizing-options from the layout-tab and the security-options from the sheet-properties (whereby those should lock more as just the sizing of the column-width)?
- Marcus
658 Views
