hide or prevent deletion of formulas in cells

From what i`ve experienced, if you protect parts of a sheet (table or raw range) that feeds a pivot table, the pivot table no longer updates.

However I want to protect formula`s that run down certain columns in a TABLE from being edited or deletable. But also have those formulas continue down their column if I add insert more rows within the table .(Possible?). I find those new rows do not carry the formulas down from above them.

Is there also a way to prevent those formulas from being seen at the same time?

Thankyou.

Probably a MAC issue, I never experienced issues with protected sheets and pivot tables.
Once a sheet is protected and you also select the hide option, the formulas won't show
Without a sample file, I'm afraid I can't help, and also, I don't know if this could be a MAC issue, I'm a Windows user

Okay, you're doing this without macros.
If you're the only one that is going to add or delete rows then you need to protect the worksheet.
It's protected now (no password).
Step 1: Unprotect the worksheet
Step 2: select the table and insert a row in the table area (I did and you see that the formula is copied)
Step 3: protect the worksheet

Now the columns with formulas are locked and the formulas invisible.
Just enter the date in the unlocked cells and it all works, repeat this for every row you want to add or add a series of rows and then protect the worksheet before entering data.
This works.

I do see that you don't treat your cell content nicely, as you see from the row I added the last column says 800. You should add and if condition to not do anything if one or more of the required columns with data is empty

When you design an actual table the formulas in the column(s) ALWAYS copies itself unless you edit something in the rows below.
VBA does help and you can do much more like editing and changing things in protected sheet, if coded correctly you don't even have to unprotect the sheet
Never too old to learn , there are loads of VBA tutorials and all very clear, you should visit Ron de Bruin's site may samples and also MAC / Windows compatibility issues are explained

Just for fun, here's my idea for inserting or appending row or rows to the table.
Happy coding

If you noticed, then you'll see that if the selected cell is outside the table you get the question if you want to append row or rows to the table.
If the selected cell is inside the table area the prompt is if you want to insert a row or rows above that point in the table.

VBA is quite straight forward and logic.
Happy coding