My feedback

1. Allow to use a power query column as a source for a data validation list

   1 vote

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   0 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz shared this idea  ·  May 09, 2018

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

   •  

   71 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   7 comments  ·  Excel for Windows (Desktop Application) » Other  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz supported this idea  ·  April 30, 2018

3. Show Tables in Power Query when opening an xlsb file

   35 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   10 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz supported this idea  ·  April 13, 2018

4. Add "Run R Script" option to Excel 2016 and Excel 2013 "Power Query" add-in, as it is for Power BI.

   158 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

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

   Hi folks,

   Thanks for your passion around this. We’ve been discussing this item off and on for some time now and we’d love to get your input.

   The reason we’ve resisted this is because the R runtime & various packages (and updating their versions) aren’t straightforward for other users to install. This limits sharing such queries across a workgroup.

   What do you think?

   For others reading this that’d like us to prioritize this work, please be sure to add your vote since we’re prioritizing our backlog based on these.

   thanks

   Ashvini Sharma
   Lead Program Manager
   Excel

   Ricardo Diaz supported this idea  ·  March 24, 2018

5. Number format thousand separator and no decimals

   311 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   89 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz supported this idea  ·  March 06, 2018

6. Power Query - Add option to retain all cells (nulls and errors) when using Unpivot Other Columns

   18 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   3 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz supported this idea  ·  February 20, 2018

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

   174 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

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

   Interesting suggestion, Wyn. Thanks for logging it.

   Others coming in new to this, please help us prioritize this item by providing your votes.

   thanks

   Ashvini Sharma
   Lead Program Manager
   Excel

   Ricardo Diaz supported this idea  ·  February 18, 2018

8. Improve Data Validation (make it AutoComplete based on typed characters)

   128 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   28 comments  ·  Excel for Windows (Desktop Application) » Editing  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Ricardo Diaz supported this idea  ·  January 25, 2018

9. Conditional formatting - Apply to named ranges

   386 votes

   Vote Vote Vote

   Sign in

   prestine

   Your name

   Your email address

   Check!

   invalid email

   (thinking…)

   Reset

   or sign in with

   • 
   • 

   

   UserVoice password

   Forgot password?

   Create a password

   I agree to the terms of service

   Signed in as (Sign out)

   Close

   Close

   We’ll send you updates on this idea

   Subscribe
   120 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
   Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, 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)

   Ricardo Diaz supported this idea  ·  September 20, 2017

10. AutoSave Master Switch rather than an "I Told YOu So!" later

    345 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    60 comments  ·  Excel for Windows (Desktop Application) » Opening and Saving Files  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Ricardo Diaz supported this idea  ·  August 30, 2017

11. Add Fiscal Month and Fiscal Year to the Query Editor "Add Column " Date Button

    24 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

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

    Thanks for logging this useful suggestion, Wyn.

    Others browsing this, please be sure to add your vote to help us prioritize this item in our product backlog.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ricardo Diaz supported this idea  ·  August 26, 2017

12. Make quick measures like in Power BI available in Excel as well

    29 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded

    Hi Imke & others,

    Thanks for logging this suggestion and voting on it. Yes indeed this would be very useful to make it easier and quicker.

    For those that’d like to get this done, please be sure to register your vote to help us prioritize against out backlog.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ricardo Diaz supported this idea  ·  July 20, 2017

13. "Blank" option to the top of the excel filter options

    •  

    45 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    3 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Ricardo Diaz supported this idea  ·  May 07, 2017

14. Is it possible to have red arrow goes up and green arrow goes down for conditional formatting ?

    17 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    5 comments  ·  Excel for Windows (Desktop Application) » Formatting  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Ricardo Diaz supported this idea  ·  May 07, 2017

15. Power Pivot - display source table name when right clicking on field in Row / Column box

    •  

    6 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    1 comment  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Ricardo Diaz supported this idea  ·  May 07, 2017

16. Add ability to collapse field areas in PivotTable Field and Area Side by Side view

    336 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    8 comments  ·  Excel for Windows (Desktop Application) » PivotTables and Power Pivot  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  Ashvini Sharma (Lead Program Manager, Microsoft) responded

    Hi Ken,

    Thanks for logging this one, and thanks to others for voting this up.. We’ve actually had this on our list to get to for some time and have been balancing doing this against other… The more the community helps us rank it higher, the better the signal on overall importance… so, for those that haven’t voted for this but want it, do vote!

    thanks
    ash [MS XL]

    Ricardo Diaz supported this idea  ·  May 07, 2017

17. Allow interaction with Excel while in Power Query

    159 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

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

    Hi Ken,

    Thanks for logging this suggestion. Yes, this could be quite useful. Others that’re interested in this, please do log your votes so we’ll prioritize this work appropriately.

    thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ricardo Diaz supported this idea  ·  May 07, 2017

18. Power Query - cache shared nodes

    1,690 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    237 comments  ·  Excel for Windows (Desktop Application) » Data Import  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    started  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded

    We are actively working on this. Thanks for your votes!

    Ricardo Diaz supported this idea  ·  May 07, 2017

19. Use F4 key to lock reference in a table

    98 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    13 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Accepting Votes  ·  AdminExcel Team [MSFT] (Admin, Office.com) responded

    Good suggestion Frederic – thanks for taking the time to post it. We’ll take a look at the F4 loop and including other functionality like this as soon as we can. We’ll be spending more time on the things with more votes – so folks that really want to see this should keep voting it up.

    Best,
    John [MS XL]

    Ricardo Diaz supported this idea  ·  May 07, 2017

20. Change Excel Table Name in the Create Table Window

    40 votes

    Vote Vote Vote

    Sign in

    prestine

    Your name

    Your email address

    Check!

    invalid email

    (thinking…)

    Reset

    or sign in with

    • 
    • 

    

    UserVoice password

    Forgot password?

    Create a password

    I agree to the terms of service

    Signed in as (Sign out)

    Close

    Close

    We’ll send you updates on this idea

    Subscribe
    8 comments  ·  Excel for Windows (Desktop Application) » Tables, Sorting and Filtering  ·  Flag idea as inappropriate…Flag idea as inappropriate…  ·  Delete…  ·  Admin →
    Ricardo Diaz supported this idea  ·  May 07, 2017