Ron
My feedback
-
2 votes1 comment · Excel for Windows (Desktop Application) » Opening and Saving Files · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Ron
shared this idea
·
-
2 votes0 comments · Excel for Windows (Desktop Application) » Performance · Flag idea as inappropriate… · Admin →Ron
shared this idea
·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Ron
shared this idea
·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →Ron
shared this idea
·
-
13 votes
An error occurred while saving the comment Ron
commented
PC too
Ron
supported this idea
·
-
129 votes29 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Ron
commented
Totally right.
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.Ron
supported this idea
·
-
91 votes19 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Ron
commented
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.
Ron
supported this idea
·
-
5 votesRon
shared this idea
·
-
289 votesRon
supported this idea
·
An error occurred while saving the comment Ron
commented
The limit is too small, it is trivial.
-
1,426 votes216 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!
Thanks
Ashvini Sharma
Lead Program Manager
ExcelAn error occurred while saving the comment Ron
commented
Re: Simon Hurst commented · May 16, 2019 11:50 PM ·
<snip>
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.
</snip>
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".Ron
supported this idea
·
-
68 votes17 comments · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Ron
supported this idea
·
-
2 votesRon
shared this idea
·
-
3 votesRon
shared this idea
·
-
6 votes1 comment · Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks · Flag idea as inappropriate… · Admin →Ron
supported this idea
·
An error occurred while saving the comment Ron
commented
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.
Here is another example file with the same problem and solution, save as through 2010
https://answers.microsoft.com/en-us/msoffice/forum/msoffice_excel-mso_win10-mso_2013_release/excel-power-query-or-vba-code-solutions-required/ff0a76bc-09b2-46d5-983c-fb0a4cd7ec3e?messageId=1fa2706b-b5f4-4578-8664-4ba3876d8469