Feedback by UserVoice

Dick Kusleika

My feedback

  1. 423 votes
    Sign in
    Check!
    (thinking…)
    Reset
    or sign in with
    • facebook
    • google
      Password icon
      Signed in as (Sign out)

      We’ll send you updates on this idea

      Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

      Thanks

      Ashvini Sharma
      Lead Program Manager
      Excel

      Dick Kusleika commented  · 

      Here's how I'd set it up: Four check boxes that are specific to tables.

      1. Allow new record (only allows adding a new record to the bottom of the table, default checked)
      2. Allow insert/remove record (can add or delete rows anywhere)
      3. Allow editing non-formula cells (default checked)
      4. Allow editing formula cells

      When you protect a sheet, and don't change any defaults, tables will be locked down except that you can modify existing rows and add a new one at the bottom. Then, if you prefer, you can allow the other two.

      Table permissions would always override non-table permissions. That is, whatever the state of the cells below or to the right of the table, they can get overwritten by adding rows or columns. Also, you can always add/remove header row and total row.

      If you want to do stuff like add or move columns, you have to unprotect the sheet.

      Dick Kusleika supported this idea  · 

    Feedback and Knowledge Base