Formula not working when Worksheet is Protected

  • Hello everyone,

    I have an excel file that have multiple formulas. When new rows are added, the formula works fine and will show.



    However, when I locked the highlighted columns in yellow with password, the formula doesn't work anymore as per below.

    Are there any additional formatting or setting that I missed out in sheet/cells protection?

    I have attached the excel file there. The password is 123.

    Thanks!

    Files

    • TEST.xlsx

      (49.35 kB, downloaded 44 times, last: )
  • The problem is that you are using a Table. Tables cannot automatically expand to include new rows when a worksheet is protected, and that is why your formula isn't filled down automatically.

    Rory
    Theory is when you know something, but it doesn’t work. Practice is when something works, but you don’t know why. Programmers combine theory and practice: nothing works and they don’t know why