Feedback by UserVoice

 

Wyn Hopkins

← Welcome to Excel’s Suggestion Box!

My feedback

  1. CTRL+M to launch Power Query Editor

    96 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

    14 comments  ·  Excel for Windows (Desktop Application) » Product Setup and Activation  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Gets my vote

    Wyn Hopkins supported this idea  · 

  2. Power Query: Make it easier to connect to files on OneDrive and SharePoint

    179 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

    22 comments  ·  Excel for the web » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Here's a link to the current 2 workarounds. Neither is very satisfactory https://youtu.be/igcCbKqtwrk

    Wyn Hopkins shared this idea  · 

  3. Let add setting to switch gridlines on/off

    18 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) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  4. Display pivot table headers in the columns headers

    35 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 →
    Wyn Hopkins supported this idea  · 

  5. Dynamic Arrays, Spill range format

    27 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

    4 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This would be fantastic

    Wyn Hopkins supported this idea  · 

  6. Auto resizing of formula bar

    246 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

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

    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]

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    I definitely want it to expand automatically while typing or editing. I’m thinking that just selecting a cell with a multi row formula would cause an indicator (expand icon) to appear next to formula bar

    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This becomes even more important now that the LET function is being introduced

  7. Make it easier to obtain Excel file path from OneDrive and SharePoint

    4 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) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Even better add a Power Query Connector : From File on OneDrive / SharePoint

    Wyn Hopkins shared this idea  · 

  8. Structured formatting of formulas

    8 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) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  9. Ability to comment within formulas

    50 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) » Collaboration and Sharing  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Yep, voted, see this same thread also https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/10635309-ability-to-comment-within-formulas

    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The syntax // is used for DAX and Power Query to comment out code

    Would be great to have that in Excel too

  10. Power Query search box or an "In Focus" tab

    18 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) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  11. Add Get Parameter button to Power Query and avoid Privacy / Formula.Firewall problems

    339 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) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    not at this time  ·  AdminExcel Team [MSFT] (Product Owner, Office.com) responded

    Hi all,

    Thank you for taking your time to suggest and vote for adding Get Parameter button to Power Query. We do think that this suggestion has merit but we don’t think that we’ll be able to devote time to it in the near future. We’ll continue tracking votes for it.

    Thanks,
    Guy Hunkin
    Excel Program Manager

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    That's a shame Guy, thanks for letting us know though.

    Any chance you can add this link (to Ken's post) to your response as a workaround:

    https://www.excelguru.ca/blog/2015/03/11/power-query-errors-please-rebuild-this-data-combination/

    Wyn Hopkins shared this idea  · 

  12. Add a Split dynamic array function

    257 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

    30 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    This is a great idea for Dynamic Arrays. Optional parameters covering:

    split at left most / right most delimiter
    Number of splits

    Wyn Hopkins supported this idea  · 

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

    112 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

    9 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  14. XLOOKUP to return an array of ranges

    18 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

    6 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Mynda Treacy's video demo's the issue nicely here
    https://youtu.be/2ViMm-wuM3U?t=561

  15. Add a floating totals row to dynamic arrays

    18 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) » Other  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Also see this idea https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/38952709-sumcols-and-sumrows-functions-for-dynamic-arrays

  16. SUMCOLS and SUMROWS functions for Dynamic Arrays

    269 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

    38 comments  ·  Excel for Windows (Desktop Application) » Formulas and Functions  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Essential to really take full advantage of Dynamic Arrays

  17. Add Power BI Dataflows as a data source in "Get & Transform Data"

    183 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

    16 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  18. Bring Power Pivot closer to Power BI Desktop Functionality

    104 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) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    I'm on board with this

    Let also add VAR and RETURN and be able to Right - Click add measures to a Measures Table.

    Wyn Hopkins supported this idea  · 

  19. Conditional formatting - Apply to named ranges

    947 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

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

    Thanks for supporting this feature. We won’t be able to in the near future, but we understand that it would be a nice improvement. Even though it seems like a straightforward idea, it is quite complex since named ranges can be dynamic, meaning that the range is calculated when the workbook is calculated.

    We’ll continue tracking votes for this suggestion.

    Wyn Hopkins supported this idea  · 

  20. Add "Edit Measure" to right-click context menu for PivotTable Fields Values Pane

    11 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) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    And on right-click in the Pivot Table itself would be awesome

    Wyn Hopkins supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base

(thinking…)