Feedback by UserVoice

Anonymous

My feedback

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

    Anonymous commented  · 

    Hi all,

    A work around which I found was to make the table an 'editable range' in the review tab and making all of the columns in the table unlocked, other than the columns involving formulas.

    Then, when protecting the sheet, ensure that 'Select locked cells' is unticked - this will unfortunately mean that the users will not be able to select or see the formulas but will allow you to sort the table.

    Useful related link: https://amazingexcel.com/allow-user-to-edit-a-specific-range-cells-in-protected-sheet/

    (Although there may be a better link/ how to out there!)

    Hope this helps anyone still struggling.

Feedback and Knowledge Base