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.


  • 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.

    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

Participate now!

Don’t have an account yet? Register yourself now and be a part of our community!