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.