Feedback by UserVoice

 

Charley Kyd

← Welcome to Excel’s Suggestion Box!

My feedback

  1. SUBSTITUTES function supporting arrays of "find" and "replace" parameters

    64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    5 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  2. SUMCOLS and SUMROWS functions for Dynamic Arrays

    171 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    23 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  3. DONT'T CHANGE MY FORMULA!!!!!!!

    6 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  4. COUNT.DISTINCT Values

    64 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  5. Update Visual Basic for Applications

    29 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    3 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  6. "Excel found a problem with one or more formula references" - Please tell me where!

    140 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    25 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  7. Pick color in Excel Like at Powerpoint

    408 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    59 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  8. When copying tabs, somtimes we have to cycle through 100s of "Yes" or "No" to the "Name already exists warning" Can we add Yes to All option

    225 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    29 comments  ·  Excel for Windows (Desktop Application) » Performance  ·  Flag idea as inappropriate…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Good news! We have released a few fixes to Insiders to address this issue. If you are on Insiders, please let us know if the fix has worked for you.

    The fixes should be in build 11809.10000 and onwards.

    -Joe McDaid [Excel Team]

    Charley Kyd supported this idea  · 

  9. Export power query or Table to CSV

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    2 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    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  · 

  10. Fix Bug in Formula Bar

    1 vote
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd shared this idea  · 

  11. Tables should default to "My table has headers" being ticked

    125 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    10 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 

  12. Allow slicers on protected sheets to be USED but not edited

    9 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd shared this idea  · 

  13. Restore MDI file handling (open all files in one window); Kill SDI (each spreadsheet opens in a seperate window)

    1,207 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    916 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for all of the votes – the team has definitely taken notice of the activity around this issue. We moved to SDI as a result of customer requests, but it looks like we’ve got work to do to really nail the use cases people care about. From a read over the comments, I see a number of cases that we will want to investigate further as we think through MDI vs SDI. We’ll get someone from the team to take a deeper look, and we may reach out to some of you for more clarification as we go. Thanks again for all the voting and passion here!

    John, Excel

    Charley Kyd supported this idea  · 

  14. Dates prior to 1900

    37 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    19 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd supported this idea  · 
    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.

  15. Update Linked Pictures (formerly called the Camera tool)

    70 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    21 comments  ·  Excel for Windows (Desktop Application) » Graphics  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd shared this idea  · 

  16. Add a MATCHIFS formula

    20 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    7 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd commented  · 

    I agree! If we want to return text from a Table, MATCHIFS would provide an easy way to do it.

    I know, there are workarounds. But they shouldn't be needed. Instead, we need MATCHIFS.

    Charley Kyd supported this idea  · 

  17. Chart gridlines on top of series as option

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    Thanks for the feedback. This is an interesting idea. We’ll consider this in our future planning. Please continue to vote on this feature idea.

    Thanks,
    Scott [MSFT]

    Charley Kyd supported this idea  · 

  18. Create function Unique(array) extracting unique values from an array

    39 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    12 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd commented  · 

    We need two functions that return arrays: UNIQUE(reference or array) and SORT(reference or array)

    Together they could return a unique, sorted lists from a Table column for use with dropdown list boxes.

    Yes, we can do this with complicated array formulas. But those formulas calculate VERY slowly with Tables of hundreds of thousands of rows. On the other hand, UNIQUE() and SORT() worksheet functions could be optimized to return their data quickly.

  19. Add a zoom feature to charts

    66 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    13 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Accepting Votes  ·  Scott Ruble (PM MSFT) responded

    This is great feedback. We are looking into the details of this. Please continue to vote on feature ideas which will increase their likelihood of getting in the product.

    Thanks,
    Scott [MSFT]

    Charley Kyd commented  · 

    This should be a setting that affects the upper and lower bounds of the chart. That way, as the data changes, the bounds adjust automatically to apply the zoom setting.

  20. Create unique object names by worksheet

    3 votes
    Sign in
    (thinking…)
    Sign in with: Facebook Google
    Forgot password?
    Create a password
    Signed in as (Sign out)
    Close
    Close

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Charting, Mapping and Visualizations  ·  Flag idea as inappropriate…  ·  Admin →
    Charley Kyd shared this idea  · 
← Previous 1

Feedback and Knowledge Base

(thinking…)