Feedback by UserVoice

Ken Puls

My feedback

  1. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  2. 685 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  3. 47 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks everyone for showing a lot of passion for adding short month name and short day name to the Power Query in Excel! We’re evaluating our future investments and your votes help us to prioritize. Please keep voting if you like this idea.

    Inbar Privman,
    Program Manager, Excel Team

    Ken Puls supported this idea  · 
  4. 12 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    In December 2020, we posted that this issue was fixed, but a few months later we realized that the change caused an unwanted side-effect, so we had to undo the fix.

    We’ll keep monitoring votes on this. Sorry for the inconvenience caused by fixing it and then taking away the fix, but the side-effect of the fix was worse.

    The side-effect was that in some cases, adding a row to a table on one sheet could cause a data validation rule to be applied to cells on another sheet where it should not apply.

    Steve [Microsoft Excel]

    Ken Puls supported this idea  · 
  5. 3 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ken Puls commented  · 

    Having the ability to set an easy filter to "The Last Year" in addition to "Last Year based on Today's date" would certainly add a bit more robustness to date filters. I think this could be especially useful for accountants as we are often dealing with finishing our year end in January, and the current date filters cause us a shift in our reporting filters before we are ready for them.

    Ken Puls supported this idea  · 
  6. 349 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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

    Ken Puls supported this idea  · 
  7. 909 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  8. 27 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  9. 656 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  10. 63 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Ken Puls supported this idea  · 
  11. 648 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for allowing interaction with Excel while in Power Query Editor window. 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.

    Guy Hunkin
    Excel Team

    Ken Puls shared this idea  · 
  12. 129 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for suggesting this feature, but this is not something we’re likely to implement anytime soon. The reality is that this sort of feature only helps to keep honest folks honest, and doesn’t provide true security, because anyone with permission to a workbook can modify that workbook. For scenarios where the database really needs to be securely maintained, a better answer is to deploy the data model to either an Analysis Services server or to Power BI. By doing that, the data model (an AS tabular database) will be maintained independently of the workbook, and users will be able to connect to the database and query it from their Excel PivotTables but will not be able to modify it.

    Ken Puls supported this idea  · 
  13. 353 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thank you for taking your time to suggest and vote for being able to protect Power Query with a password. This is a good idea, but we don’t think we’ll be able to support this in the near future. We’ll continue tracking votes for it.

    Guy Hunkin
    Excel Team

    An error occurred while saving the comment
    Ken Puls commented  · 

    Joana, I agree. Contrary to the anonymous comment, as a developer of BI information, there are times that I'll want a user to only be able to refresh and not modify the underlying query makeup. The ability to protect a Power Queries M code should exist.

  14. 1,562 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for logging this great suggestion, Zack, and to others for voting it up. We’ll prioritize this according to the number of votes, so if there’s more interest, please make sure to register your vote!

    Thanks

    Ashvini Sharma
    Lead Program Manager
    Excel

    Ken Puls supported this idea  · 
  15. 24 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    An error occurred while saving the comment
    Ken Puls commented  · 

    Agreed. This would be really useful for reporting expenses in an income statement. (Expenses are good when they are lower than budget, so the green arrow needs to point down.) Even better would be to allow us to upload our own icon pictures for use in conditional formatting.

    Ken Puls supported this idea  · 
  16. 181 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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]

    An error occurred while saving the comment
    Ken Puls commented  · 

    I agree that using F4 to toggle the relative and absolute referencing for table headers would be valuable. This is far from discoverable and would make this a much more consistent experience with other formulas.

    Ken Puls supported this idea  · 
  17. 486 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    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]

    Ken Puls shared this idea  · 
  18. 834 votes

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    We’ll send you updates on this idea

    Thanks for your support for this suggestion. As some of the comments have concluded, there are a few complex technical issues and considerations that have delayed this from being implemented.

    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.

    One of the primary reasons for this request was to have a better way to handle formula cells in line charts, and this can be accomplished using the option to show #N/A as an empty cell. You can use the NA() function in your formulas as appropriate, and choose the option to “Show cells with #N/A as an empty cell”. To find the option for your chart, go to the Select Data dialog for the chart, and click the Hidden and Empty Cells button.

    We know there are other scenarios where a proper NULL()…

    Ken Puls supported this idea  · 
2 Next →

Feedback and Knowledge Base