My table does not auto-insert all the formulas when a new row is inserted

[reemav]

Hi,

My excel sheet has 5 columns with formulas. I converted it into a "Table" so that those formulas auto-fill whenever I insert a new row (between rows). 

Upon inserting a new row, only 4 out of 5 columns will auto-fill the formula. I've checked and all the necessary columns are included in the "Table".

Can anyone advise why this is happening?

[#2]

@reemav 

You have somehow broken the table autofill.

Delete all formulas in the column except one. Go to that cell with the formula and press F2 and ENTER.

[#3]

Hi Detlef Lewin,
I've tried doing the above but it still does not work..
Also tried redoing the entire excel sheet from scratch and realised the table autofill gets broken when i try to "lock" those cells and "protect" the excel sheet.
Not sure why..

[#4]

@reemav 

Take a look at some of the suggested solutions:

https://www.google.com/search?q=protect+ecel+sheet+with+a+table