I have a spreadsheet that has multiple tabs and many Tables that reference each other. The Tables have both data and formulas. When locking a column in a Table with a formula, the entire Table becomes locked. I would like it such that I can lock the columns with formulas but allow users to sort the table but not edit it. Any suggestions? Thank you.
Bookmarks