My feedback

1. Fix the "There's a problem with the clipboard" issue

   69 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   87 comments  ·  Excel for Windows (Desktop Application)  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

   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  ·  March 24, 2021  ·  Edit…  ·  Delete…

   This only happens to me when I'm using Power Query.

   Save Submitting...

2. Allow INDIRECT to work with dynamic names

   13 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd shared this idea  ·  January 16, 2021

3. An array of arrays of arrays

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd shared this idea  ·  January 16, 2021

4. ARRAYCONC() formula to concatenate dynamic arrays (or non dynamic ones too)

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   An error occurred while saving the comment
   Charley Kyd commented  ·  December 25, 2020  ·  Edit…  ·  Delete…

   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!

   Save Submitting...

5. VBA doesn't save pictures

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » Macros and Add-ins  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd shared this idea  ·  November 24, 2020

6. Bug: Tables no longer expand automatically

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
   Charley Kyd shared this idea  ·  November 24, 2020

7. Add a Split dynamic array function

   •  

   298 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   30 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd supported this idea  ·  July 14, 2020

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

   135 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   11 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd supported this idea  ·  January 22, 2020

9. SUMCOLS and SUMROWS functions for Dynamic Arrays

   291 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   45 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Charley Kyd supported this idea  ·  January 22, 2020

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

    12 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Charley Kyd supported this idea  ·  December 28, 2019

11. COUNT.DISTINCT Values

    65 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Charley Kyd supported this idea  ·  December 28, 2019

12. Update Visual Basic for Applications

    40 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

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

    290 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    34 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Charley Kyd supported this idea  ·  December 28, 2019

14. Pick color in Excel Like at Powerpoint

    •  

    1,166 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    109 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    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  ·  December 28, 2019

15. Export power query or Table to CSV

    23 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    4 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    An error occurred while saving the comment
    Charley Kyd commented  ·  December 28, 2019  ·  Edit…  ·  Delete…

    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.

    Save Submitting...
    Charley Kyd supported this idea  ·  October 09, 2019

16. Fix Bug in Formula Bar

    •  

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Edit…  ·  Delete…  ·  Admin →
    Charley Kyd shared this idea  ·  December 27, 2019

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

    •  

    147 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

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

    12 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

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

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

    1,311 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    968 comments  ·  Excel for Windows (Desktop Application) » Viewing / Navigating Workbooks  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook.
    – Links: The behavior of linked workbooks should not be affected by whether the workbooks appear in a single window or multiple windows. If you need to open a separate instance of Excel to avoid updating links, you can still do so by holding ALT when you click the shortcut to start Excel, or by running the command “Excel.exe /x”.
    – Closing workbooks: To close all documents and exit Excel, you can either right-click the Excel icon in the task bar and choose “Close all windows”, or you can add the “Exit” command to the quick access toolbar. Then use this button to close all your workbooks with a single click.

    For other issues, it would be great to deal with those specifically, either by submitting a separate suggestion here on UserVoice, or by sending feedback within Excel. For example, if there are specific issues with VBA, whether they’re related to SDI or not, please submit that feedback.

    If you’d like to find out about the Excel team priorities, please read this post on our TechCommunity – https://techcommunity.microsoft.com/t5/excel-blog/excel-product-team-fy20-goals/ba-p/1342022.

    Thanks for the support and the detailed discussion around this suggestion. We understand that there are some advantages and disadvantages with both MDI (multi-document interface) and SDI (single-document interface), and we currently do not have plans to revert to MDI. We do want to improve the experience with SDI so you can get your work done efficiently, and this post has helped toward that goal.

    Some of the specific issues mentioned are addressed as follows:
    – Stability: This has been a focus over the past several years, and the monthly releases in 2020 have been among the most reliable ever in terms of avoiding crashes.
    - Screen space – while it won’t get all the space back, you can minimize the ribbon to save some space. It only shows when needed.
    - Navigation between workbooks: you can use CTRL+F6, SHIFT+CTRL+F6, CTRL+TAB or SHIFT+CTRL+TAB to switch to the next workbook. … more

    Charley Kyd supported this idea  ·  June 09, 2019

20. Dates prior to 1900

    56 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    28 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Charley Kyd supported this idea  ·  March 03, 2018
    An error occurred while saving the comment
    Charley Kyd commented  ·  March 03, 2018  ·  Edit…  ·  Delete…

    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.

    Save Submitting...