Feedback by UserVoice

 

Wyn Hopkins

← Welcome to Excel’s Suggestion Box!

My feedback

  1. Let add setting to switch gridlines on/off

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

  2. Display pivot table headers in the columns headers

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

  3. Dynamic Arrays, Spill range format

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

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

    134 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

    17 comments  ·  Excel for the web » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins shared this idea  · 

  5. Auto resizing of formula bar

    238 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

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

    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

    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  · 

  7. Structured formatting of formulas

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

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

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

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

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

  11. Add a Split dynamic array function

    216 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

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

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

    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

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

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

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

  15. SUMCOLS and SUMROWS functions for Dynamic Arrays

    249 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

    35 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

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

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

  17. Add a Reporting Ribbon to Excel to consolidate and highlight the amazing capabilities of Power Query and Power Pivot

    299 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

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

    Plus.... a Get Parameter button that avoids the formula firewall...

    Sorry to cross post, but folks who like this idea may well like this one
    https://excel.uservoice.com/forums/304921-excel-for-windows-desktop-application/suggestions/32691571-add-get-parameter-button-to-power-query-and-avoid

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    If I could edit my suggestion I would. Let's call it what it is... POWER features. Adding a Publish to Power BI button would be great too. Some good options listed in Sameer's post a few items below this one

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    OK, so let's call it the POWER tab (see image)

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Hi Bill, the name is tricky, and I'm sure there's probably a better name.

    I'm looking at it from who it's aimed at / why have a separate ribbon. The reason is awareness for those users who simply miss out because these new features are hidden away.

    How do we capture their attention, what resonates at a general level? I'm not particularly set on "Reporting" as a name but it does sort of capture why someone should look at this ribbon.

    If your job involves reporting and you're not using Tables, Power Query, Pivot Tables and Power Pivot then you're missing out.

    To me reporting is something dynamic and interactive that requires regular refreshing / updating.

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Sergei, definite room for improvement on my hacked together version. The Power BI publisher features I'd like to see on there too. Plus I'm sure the Excel team will have some usage stats on most popular Get From button - personally I'm always using from Excel or From Folder, but others will be different.

    Calling it out as an awesome set of features is the key to me (plus grouping together the whole data analysis / reporting story into a cohesive place).

    An error occurred while saving the comment
    Wyn Hopkins commented  · 

    Plus the Power BI Publisher buttons would be great. Although I'd rename them as Power BI Connector :)

    Wyn Hopkins shared this idea  · 

  18. Bring Power Pivot closer to Power BI Desktop Functionality

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

    910 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

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

    Thanks to Graham for starting this conversation. If you would also like Excel to maintain named range references and structured table references in the “applies to” field for Conditional Formatting rules, please add your comments and vote this one up. We will prioritize accordingly.

    Thanks,
    Steve (MS Excel)

    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…)