Issue with protections on a table - Excel

Copper Contributor

Hi All

 

I have a spreadsheet where to the left is free text columns but to the right is a table where I protected the cells. Without protection the table expands automatically but with the protection it does expand the table. In the table there are formulas which I want to stop users of the file deleting them but jut enter data to the left of the table. With protection off the table expands but when protection is on it won't 

 

I really could do with some assistance or help. The version I am using is 1812.

 

I have attached the sheet I am issues with so that you can see the problem

1 Reply
This is a known bug with Tables and sheet protection. There's no fix as of yet.