2 votes0 comments · Excel for Windows (Desktop Application) » PivotTables and Power Pivot · Flag idea as inappropriate… · Admin →
253 votes49 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →
I would like to add that it shlould be also allowed to modify the tables in protected sheets via VBA.
Now you can't, even if when you protect the sheet with the VBA option UserInterFaceOnly: = True.
To be able to work with tables, through VBA, we have to unprotect and protect the sheets each time.
126 votes10 comments · Excel for Windows (Desktop Application) » Data Import · Flag idea as inappropriate… · Admin →
Of course, we use both Excel and Power BI. But with Excel environment only, is not possible to protect the Queries.
The point is, as well as you are able to protect the formulas, VBE, … and any other modifications in an Excel workbook, why this is not possible with Power Query.
Of course in some chats they explain how to do it, for ex. (http://stackoverflow.com/questions/37444536/how-to-password-protect-power-query-queries), but I think that the tool should let the users to do it without such alternative ways.
Sure I have not explained well in my request.
Power Query queries are basic in the data model that later on is designed, any change on the queries can affect decisively on results and may even cause it to stop working.
Of course the connections can be protected in Power Query, they already have password as they have in the source systems.
What I ask for, is that when a file (which has a data model created with Power Query) is distributed to the users be able to protect the queries from users modifications.
If users want to learn Power Query no problem, it is possible to send the unprotected Queries to practice. But when you send official reports which have important data and measures to the users they should not practice with that.
I have had already problems on this subject.
92 votes0 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
1,213 votes333 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
Thanks for the post Caleb. As some folks in the comments mention, you can change the format of the cell to Text before the paste. But even so, it’s clear that there’s some user pain around this experience. We hear you and we’ll evaluate how we can do a better job here. As always, we’ll spend the most time/attention on the things with the most votes, so please keep voting for things you want the most.
John [MS XL]
Thanks to everyone who has voted for this suggestion. The title has been updated so that it mentions Power Query, but no longer mentions Power Pivot or Power Map. Please add your votes to separate suggestions for those features. Keeping the suggestions separate will help make the voting more meaningful.
Thanks – Steve K [MS Excel]