7 Replies Latest reply: Apr 1, 2014 11:29 AM by Anand Chouhan RSS

    Lock Pivot table

      Dear community,

       

      Attached herewith the sample, I have pivot table with InputSUM column which should be locked.

      If i select either Detached or Read Only, i will not able to change the value in InputSUM column, so that is not a good idea.

      How should i lock this table so that user is unable to filter or select any selection from this table while they still can edit data in the inputSUM column?

       

      The purpose of asking this is because user might accidentally filter some selections by miss clicking some cells, when entering data in inputSUM column.

       

      Original table:

       

      Accidentally clicking 100 that make filter to that row: (undesirable)

       

      Desirable result: (But Detached is not a good solution as mentioned above)

       

      Thanks,

      Chanel