Charley Kyd
My feedback
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
shared this idea
·
-
269 votes21 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Thanks for the suggestion. I think I’ve seen some related requests, I’ll look at merging them to make sure the votes properly reflect the ask. We’ll prioritize this into the execution pipe appropriately based on the number of votes.
Cheers,
John [MS XL]Charley Kyd
supported this idea
·
An error occurred while saving the comment -
5 votes1 comment · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Charley Kyd
commented
I suggest a slight variation to this suggestion.
Leave the current formula bar as it is. Instead, give us an optional Formula pane at the right. That way, we can work normally when we work with traditional functions, but we would have quick visibility for LET, LAMBDA, nested-IF functions, and so on.
In fact, that area could have two panes, one for an enhanced IntelliSense feature, and one for the formula itself.
Charley Kyd
supported this idea
·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
Hi,
Sorry for this experience. When exactly does it freeze, is it right after loading the workbook? I can’t reproduce the issue. So, it would be great if you can “Send a Frown” from the workbook when you experience the freeze as that would provide us the logs to investigate this further. To send a frown, follow the instructions here – https://support.microsoft.com/en-us/office/how-do-i-give-feedback-on-microsoft-office-2b102d44-b43f-4dd2-9ff4-23cf144cfb11 and select “I don’t like something”. Enter “Attn : abkodank” in the textbox and hit Submit.
Thanks
Charley Kyd
shared this idea
·
-
58 votes33 comments · Excel for Windows (Desktop Application) » Editing · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Charley Kyd
commented
It wouldn't be difficult to implement. Here's how:
The "obvious" solution would be to count backwards from 0. But because Microsoft hasn't done that, there might be a technical reason they can't use that method--like maybe 3 zillion lines of code that would need to be changed. So here's another approach:
The date 1/0/1900, which is zero, is unused anyway. Microsoft could use the numbers to the right of zero's decimal point to define a wide range of date values. For some number of centuries it could track month, day, and year. For earlier times, it could track month and year, and so on, getting less precise the further backwards it went. With the right number taxonomy, those decimal numbers could satisfy genealogists, historians, paleontologists, and even astronomers...all without affecting dates from 1/1/1900 forward.
To illustrate, the taxonomy could specify that the date serial number 0.387930112 specifies 375 million BC, when fish first left the water.
Additionally, of course, we'd need a few functions to convert between text and an old-date serial number, and between Gregorian and Julian.
Wikipedia says that Excel has a numeric precision of 15 significant figures to the right of the decimal point. Or maybe a little less because of technical reasons. But even 12 or 13 numbers to the right of the decimal point would provide a LOT of room to satisfy nearly everyone.
Charley Kyd
supported this idea
·
An error occurred while saving the comment Charley Kyd
commented
Negative date-time values currently have no meaning. It would be easy to use those values to cover ALL dates prior to 1900. With the right approach, astronomers, geologists, paleontologists, historians, genealogists, and so on, could use dates prior to 1900. To do so, however, we’d lose the ability to work with the time of day prior to 1900.
The scaling would take some thought to define. The Gregorian dates could go back, perhaps, to Monday, Jan 1, 4713 B.C...the beginning of the Julian calendar. Further back, there’d be a span where only years were tracked. And then centuries, and so on.
This adjusted scaling makes sense, because, for example, the K-T event happened about 65.5 million years ago. But no one will ever be able to say (or want to) that it happened on Tuesday, May 16, 65487 BC at 2:49 am, GMT.
And also, along the way, there's be a function that could convert between Gregorian and Julian dates.
-
314 votes33 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
91 votes
Thank you for voting for “there’s a problem with the clipboard” issue. I think this refers to this error dialog: “There’s a problem with the clipboard, but you can still paste your content within this workbook."
When Excel shows this dialog after a copy (CTRL+C) action, it means that another app has a lock on the system clipboard. In this situation you can still paste within Excel. However you cannot paste to another app like Word or Outlook which uses the clipboard.
A while ago we made some improvements for Office365 users so that this error message only shows once per Excel instance. This was based on customer feedback – the design change prevents it popping up multiple successive times when the clipboard is locked. We have also considered never showing the error dialog, but there was user feedback that this message is informative and helpful in some cases.
An error occurred while saving the comment Charley Kyd
commented
This only happens to me when I'm using Power Query.
-
19 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
shared this idea
·
-
3 votes1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
shared this idea
·
-
1 vote1 comment · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Charley Kyd
commented
YES!!!!
We REALLY need a function like that! Perhaps it could be called APPENDARRAY. Or perhaps it could be something as simple as:
{Array1, Array2, Array3}
I run into the need for it all the time!
-
2 votes0 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →Charley Kyd
shared this idea
·
-
1 vote0 comments · Excel for Windows (Desktop Application) » Tables, Sorting and Filtering · Flag idea as inappropriate… · Admin →Charley Kyd
shared this idea
·
-
138 votes11 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
299 votes45 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
12 votes4 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
65 votes6 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
40 votes3 comments · Excel for Windows (Desktop Application) » Macros and Add-ins · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
296 votes35 comments · Excel for Windows (Desktop Application) » Formulas and Functions · Flag idea as inappropriate… · Admin →Charley Kyd
supported this idea
·
-
1,206 votes111 comments · Excel for Windows (Desktop Application) » Formatting · Flag idea as inappropriate… · Admin →
Thanks for this suggestion. If you’d like to see the eye-dropper tool to pick a color in Excel like you can in PowerPoint, please vote for this idea.
Steve [Microsoft Excel]
Charley Kyd
supported this idea
·
-
25 votes4 comments · Excel for Windows (Desktop Application) » Other · Flag idea as inappropriate… · Admin →
An error occurred while saving the comment Charley Kyd
commented
Although DAX Studio does this...
...It's a multi-step manual process. But PQ could allow the process to be part of a query...sort of a Table.Buffer on steroids.
...I suspect that most companies allow only a small list of add-ins to be installed.
...It requires the use of Power Pivot, which also should have this feature.
Charley Kyd
supported this idea
·
The problem that this suggestion is trying to solve is very real. But please DON'T give us this feature as described! Doing so would make our workspace a moving target.
Instead, give us a Formula pane at the right, much like a Format pane. That way, when we edit cells with traditional formulas, we can use our formula bar. But if we're editing LET, LAMDA, or other long formulas that we want to wrap, we can use our Formula pane.
And with regard to LAMBDA, you also should give us a Named Formula pane.
See: https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/43306911-formula-bar-position