Feedback by UserVoice

Oliver Wilcock

My feedback

  1. 1,029 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Signed in as (Sign out)

    We’ll send you updates on this idea

    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!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Oliver Wilcock supported this idea  · 
    Oliver 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.

Feedback and Knowledge Base