Feedback by UserVoice

 

Wyn Hopkins

← Welcome to Excel’s Suggestion Box!

My feedback

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

    12 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 the web » Data Import  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins shared this idea  · 

  2. Auto resizing of formula bar

    224 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

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

    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

    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  · 

  4. Structured formatting of formulas

    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

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

  5. Ability to comment within formulas

    47 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

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

  7. Add a Split dynamic array function

    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

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

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

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

  9. XLOOKUP to return an array of ranges

    14 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

  10. Add a floating totals row to dynamic arrays

    16 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

  11. SUMCOLS and SUMROWS functions for Dynamic Arrays

    193 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

    33 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

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

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

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

    259 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

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

  14. Bring Power Pivot closer to Power BI Desktop Functionality

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

  15. Conditional formatting - Apply to named ranges

    831 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

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

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

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

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

    160 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

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

    Agreed

  18. Excel hex color codes for formatting

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

    Good idea

    Wyn Hopkins supported this idea  · 

  19. Stop Copy & Paste overwriting Data Validation

    82 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 Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 

  20. More information for Err: "A PivotTable Report cannot overlap another PivotTable Report"

    16 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) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…  ·  Admin →
    Wyn Hopkins supported this idea  · 
← Previous 1 3 4 5

Feedback and Knowledge Base

(thinking…)