Feedback by UserVoice

 

James Denman

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Show Tables in Power Query when opening an xlsb file

    48 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    James Denman supported this idea  · 

  2. Get Tables working on protected sheets (add rows, sort, filter, etc.)

    871 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    140 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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

    James Denman commented  · 

    This has become significantly more acute since the introduction of Power Query. PQ is so powerful, but when you want to use a PQ result (in a table, of course) in a sheet which needs to be published to users and protected from them messing around with it, then... you're screwed. It's not as if the need to protect worksheets is going to go away, nor the usefulness of PQ; and there's already a protection option to let users use PivotTables.
    Time for MS to fix this.

    James Denman supported this idea  · 

Feedback and Knowledge Base

(thinking…)