Feedback by UserVoice

Yossi Geretz

My feedback

  1. 932 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    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

    Yossi Geretz supported this idea  · 
    Yossi Geretz commented  · 

    This is a great idea - MUST HAVE. I am publishing a table. I'd like to solicit feedback by having the audience fill out the table and return to me. Several columns in the table are calculated. I want to lock the audience out of those columns. But as soon as I protect the sheet, the entire table is effectively locked.

    As an aside, I would suggest that the protection paradigm in excel has been broken, or at least lacking a major use case for some time now. It should be much easier to lock a column while leaving the ability to add rows in an unfettered manner. This would effectively ensure that each row added would conform to the locked in columnar structure. This is a major use case. Can we get this to work with tables?

Feedback and Knowledge Base