48 votes13 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
871 votes140 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
ExcelJames 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.