Allow INSERT of Rows in Table with Locked Columns
I would like to provide a table to a user where the formula (calculated columns) are Locked. I do this by Locking the relevant column(s) and protecting the worksheet. When I do this, the user cannot extend the table by inserting rows. It seems this cannot be done in the Windows version either. A chance for the Mac developers to take the lead!

1 comment
-
Pip commented
Alternatively, a mechanism to just protect the formulas without having to protect the worksheet. There are various work-arounds to this involving data validation on the columns with formulas but that just slows everything down.