Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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.
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
Marcus,
Thanks for your reply.
AFAIK I didn't put it in a container.
So it's a bug?
R.W.
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