1,028 votes165 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
Excel tables have a default feature by which if we enter data in the row immediately following the last row of the table, it will auto-expand and include the new row as part of the table. This feature does not work if the sheet is protected. So, if we have a table in which the user needs to keep adding data to, we usually keep the sheet unprotected. Hope you would solve this issue to keep our formula’s safe in the new users.Mohamed supported this idea ·