Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello, I have a pivot table, in this table I need block the accion of adjust of the columns, how i do this ?
Thanks.
Hi Jesus
You need to go to Layout tab's Pivot Table and uncheck Allow Move/Size and Check Size to Data and additionally of you don't want to allow users to move the columns and Row order, go to Presentation tab and Uncheck Allow Pivoting.
Hope this helps!
Hello Emmanuelle, I know you, I working in OpenTech, i does each point you mention but the pivot table uniformly increases width. When I increase width of one column, all columns increase.
Hi
Try like this
Sheet properties-> Uncheck Move/size Sheet objects.
Its resolve that.
Note:
You can't able to move any objects.
Hi Jesus
As Mayil Vahanan Ramasamy commented but missed the tab name:
you have to go to Sheet properties-> Security-> User privilegies-> Uncheck Move/size Sheet objects.
But there a little detail with a bug:
63012
Columns still resizable in AJAX even after option to lock it is checked.
So you have to Upgrade QV Server to 11.2 SR4 to have this working and so this is solved.
I've already Test it and works.
Best Regards!!!
hi
Right clik on pivot--> properties--> layout tab --> uncheck the Size to data.