Feedback by UserVoice

Alexis Taylor

My feedback

  1. 635 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

      Alexis Taylor commented  · 

      I work in a regulated industry where it's important to be able to demonstrate that once set up and validated to work a certain way, a spreadsheet isn't going to be accidentally or maliciously changed to alter that behaviour. At the same time, most of our spreadsheets are only of any use if they can be continually expanded to add new list entries at the bottom. So what's needed is the ability to 'lock' a table while allowing it to add new lines which will duplicate the formulae, formatting (including conditional formatting) and data validation rules of previous rows.

      Medical devices, pharmaceuticals and other regulated industries are huge, affluent and subject to these and similar rules. I can't be the first person to have these two simultaneous - and, within the way Excel currently works, conflicting - requirements. How does everybody else get round this contradiction? Simply by not using Excel?

      Alexis Taylor supported this idea  · 
    • 761 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 again for all the passion on this issue – we hear you and we’ll get someone on the team to dig in to the issue. I’ve seen a few related sub-issues while scanning over the comment section for this one, so we may reach out to a few of you for clarifications. Thanks again for all the votes, and keep them coming for the issues you care about!

        John, Excel

        Alexis Taylor supported this idea  · 

      Feedback and Knowledge Base