Feedback by UserVoice

 

Wyn Hopkins

← Welcome to Excel’s Suggestion Box!

My feedback

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

    338 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

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

    Thanks everyone for showing a lot of passion about Dataflows data connector in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Guy Hunkin
    Principal Program Manager
    Excel Team

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The new Power Query Rich Data Types functionality should be added here also rather than via the “featured table” option in Power BI

    Wyn Hopkins supported this idea  · 

  2. Open find with options

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

    Agreed, just show the expanded box

    Wyn Hopkins supported this idea  · 

  3. New Formula editing experience

    95 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 →
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    - expands and indents with Shift Enter
    - allow comments
    - can be detached and floated
    - formula can be named ( for lambdas)
    - allow auto expanding of formula bar to be turned off and on easily
    - colour coding when referencing variables
    -

    Wyn Hopkins shared this idea  · 

  4. Data validation - allow Table references as List Source.

    40 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) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 
    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    The Current Channel version now allows referencing to the cells in a Table column ( and the validation picks up the new items ) https://youtu.be/MD_iLh-UEmQ

  5. CTRL+M to launch Power Query Editor

    111 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  · 

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

    221 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

    31 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  · 

  7. Let add setting to switch gridlines on/off

    21 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  · 

  8. Display pivot table headers in the columns headers

    57 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  · 

  9. Dynamic Arrays, Spill range format

    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

    5 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  · 

  10. Auto resizing of formula bar

    254 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) » 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

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

    5 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  · 

  12. Structured formatting of formulas

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

  13. 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

  14. 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  · 

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

    345 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  · 

  16. Add a Split dynamic array function

    283 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  · 

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

    129 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

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

  18. XLOOKUP to return an array of ranges

    17 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

  19. Add a floating totals row to dynamic arrays

    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

    8 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

  20. SUMCOLS and SUMROWS functions for Dynamic Arrays

    287 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

    43 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

← Previous 1 3 4 5

Feedback and Knowledge Base

(thinking…)