Posted inExcel
Feedback collection
2 years ago
Get Tables working on protected sheets (add rows, sort, filter, etc.)
Last edited by The Microsoft Feedback Team 2 years ago
I would like to be able to have the ability to add/remove rows of a table which resides on a protected sheet. Currently if you protect a sheet you can't insert/delete rows of a table. Even if you unprotect all cells and allow inserting/deleting of rows on sheet protection, it doesn't matter and is completely ignored. What I am proposing would have to follow specific rules: Table cells would have to be unprotected Cells below table would have to be unprotected (truly optional) Insert Rows would have to be specified in sheet protection The way table rows are inserted is different than a standard row insert. If there are blank rows below the table it will extend to those rows, and not shift things down. If there is data below the table, it will extend to all rows between the two, and then start inserting. This mechanism would make the second item above optional depending on how you [Microsoft] would handle this internally. My preference would be to have the cells unlocked, and honor the protection status of the cell, and not overwrite, or "consume" if there is space available.
We're looking into this
WebWe're looking into this
Official Microsoft response
Steve K.
Official Microsoft response
2 years agoThanks for logging this great suggestion 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
Vote
30 comments