• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Locking Cells with Formula in Dynamic Table

N

Nagesh Volety

New Member
Hi Friends,


I have a Dynamic table created with formula in it, for few of the columns, but I need to lock them since the user may tend to medle with formula, Hence these needs to be locked, but the table should be extended with formula, for a new entry


Please help


Thanks in advance,

Nagesh
 
Hello,


I wonder if someone could help me solve this problem.


I converted my data into a dynamic table with table options. I tried to protect my worksheet with 'protect worksheet' with the objective to hide and protect formulas. I first selected all the worksheet and in format I unticked 'locked' cell and then selected the range to format hide and locked. then I protect worksheet and give all permissions, to add data, to delete data, rows. but when I try to add data doing Tab to appear another row witht he same formats and formulas than the previous rows (as normally does in dynamic table) it doesn't let me do it, it goes to the very first data of the table. I want to add data into the dynamic table, to add automatically a row with the same formats everytime as normal, and it doesn't happen when it's protected


is this normal, is there some tip to make it work? or how other way I can protect formulas from being deleted in a dynamic table.
 
You must log in or register to reply here.
Back
Top