963 votes187 comments · Excel for Mobile Devices, Tablets, Phones (Android, iOS, Windows Mobile) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
1,073 votes174 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
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!
Lead Program Manager
It's likely that the reason you're locking the worksheet is that you're trying to protect formulas from accidentally being overwritten during data entry.
I've a number of applications wherein I use tables to collect data in columns and perform calculations on that data in other other columns. Need a way to add a new row to the table (for new data) replicate the formulas, allow a user to enter data while not allowing them to overwrite the replicated formulas on that new line.