New data in a new row of protected Table (not in range) doesn't include that row into tab.|General Excel Questions & Answers|Excel Forum|My Online Training Hub

Hi Folks,

I have a problem with relatively complicated table (not a range!) which is in addition connected to several queries and is also co-edited from another colleagues via Excel365 (where macros are not working).
From that reason I have to protect the sheet to prevent others to change some columns where are the formulas. In the Protection set is almost everything ticked as allowed.
In unprotected version as far as I add a new data in the last new row, after adding data in certain column it automatically creates a new "Table" row (table will upgrade to new size) and all the defined formulas and setups in cells per column are automatically added to new row as well. But in the protected version it doesn't work.
1. Do you have an Idea how to solve this problem (Table (not a range) functionality when is protected)?
2. Maybe I am hitting the edge of possibilities of excel (importing queries, query in query and editable query, dynamically adding the data in cells with INDEX(MATCH) functions, etc.) and question is if I should think of other platform using database?

Thank you very much in advance for any input.

Ch.

In an attachment: an excel file (took out the macros and queries)