💻 Software
Excel: lock sheet, but keep tables expandable
Fresh5 days ago
Mar 15, 202612287 viewsConfidence Score0%
0%
Problem
My goal is to protect a sheet, but make users able to edit and add rows to the contained tables. When I try to protect the sheet with no cells locked, the tables become unable to add rows even though their cells are not locked. I have tried to check all the Allow all the users of this worksheet to …
Unverified for your environment
Select your OS to check compatibility.
1 Fix
Canonical Fix
Unverified Fix
New Fix – Awaiting Verification
Fix for: Excel: lock sheet, but keep tables expandable
Low Risk
You can use a macro to make changes on locked worksheets. For example: Please read this article for more about running macros on protected worksheets. If you need help on writing the macro, you can ask for help on our sister site StackOverflow.
Awaiting Verification
Be the first to verify this fix
Sign in to verify this fix