72 votes15 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
As the author of the workbook I am supposed to know what is required in the column. Simply allowing users to accidentally paste that work out of existence.
Allow them to paste, but the paste has to pass the validation.
74 votes10 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
What's the point investing time to create a restricted validation list if it can simply be pasted over. Allow paste value, that has to pass validated, fine. But my validation is more important than the user's ability to copy and paste into MY design.
The limit is too small, it is trivial.
1,141 votes177 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
Re: Simon Hurst commented · May 16, 2019 11:50 PM ·
Presumably there is no progress on this because the Access team have forbidden the Excel team from dealing with this very significant flaw in case it means that Excel can be used for basic database stuff rather than using a proper database.
I don't think that is a problem. PowerPivot and DataManager give Excel lots of DB functionality. And take a look at the FREE download PowerBI. It too does a lot of DB "functions".
49 votes15 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
6 votes1 comment · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →
This is not a problem limited to Excel. It also happens in Word to a lesser extent. It is all part of the DUMBING DOWN of Office desktop applications to allow them to work on teeny tiny PORTRAIT smartphone screens to the detriment of large LANDSCAPE 16:10 desktop monitors. Desktop monitors do not have vertical space to waste, the ribbon is to phat already.
I thought one of the key features of Win 10 was that feature to redraw stuff to fit the screen. Why is this change hardcoded into Office apps. It should be a dynamic change based on the computing environment.