I dont think you can add a new row in a table on a protected worksheet and pass down the formula from the row above to that new row?
attached sheet,
protect password cell8
here I unlock these cells
Screenshot_20200419131013.png
these columns are locked and hidden, they contain the formulas.
Screenshot_20200419131057.png
the protect sheet settings
Screenshot_20200419131129.png
when I insert a new row, the formulas dont copy down.
Screenshot_20200419131228.png
Bookmarks