1,335 votes209 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
ExcelOliver Wilcock supported this idea ·
An error occurred while saving the commentOliver Wilcock commented
Thanks, Eckhard, for expanding the scope of what could be much better about structured tables. I've also been frustrated by data validation along with the show-stopper protected sheet issue. I didn't know the workaround you described.
I've also cursed Microsoft when trying to retrieve data through ODBC/Jet. The table is not stored as a range and Jet doesn't find it.
I've found business users very reluctant to embrace tables and I think the largest barrier is the behaviours when adding, removing and especially moving columns (cut and paste). I haven't fully wrapped my head around what it does. I know it messes up the column widths. The workaround I use is to insert a new column in the sheet and then to cut and paste the table "Entire Table Column" into the new location and then delete the unwanted sheet column. Unnecessary hassle.